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:
|
||||||||||
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. |
See Also
Reference
Replication Views (Transact-SQL)
Concepts
Heterogeneous Database Replication