.png)
MSdatatype_mappings (Transact-SQL)
The MSdatatype_mappings view maps SQL Server data types to data types used by non-SQL Server database management systems (DBMS). This table is stored in the msdb database.
Column name | Data type | Description |
|---|---|---|
dbms_name | nvarchar(128) | Is the name of the DBMS, and can be one of the following values: ValueDescription MSSQLSERVERThe destination is a SQL Server database. ORACLEThe destination is an Oracle database. DB2The destination is an IBM DB2 database. SYBASEThe destination is a Sybase database. |
sql_type | nvarchar(128) | Is the SQL Server data type. |
dest_type | nvarchar(128) | Is the name of the non-SQL Server data type. |
dest_prec | bigint | Is the precision of the non-SQL Server data type. |
dest_create_params | int | Internal use only. |
dest_nullable | bit | Is if the non-SQL Server data type supports a NULL value. |
