TechNet
Export (0) Print
Expand All

sysdatatypemappings (Transact-SQL)

 

Applies To: SQL Server

The sysdatatypemappings view is used to show the mapping between SQL Server data types and data types of a non-SQL Server database management system (DBMS). This view is stored in the msdb database.

Column nameData typeDescription
mapping_idintThe ID of the data type mapping.
source_dbmssysnameIndicates the name of the DBMS from which the data types are mapped, and can be one of the following values:

 MSSQLSERVER = The source is a SQL Server database.

 ORACLE = The source is an Oracle database.
source_versionsysnameIndicates the product version of the source DBMS.
source_typesysnameIndicates the data type listed in the source DBMS.
source_length_minbigintThe minimum length of the data type at the source DBMS, where a value of NULL indicates that length is not used.
source_length_maxbigintThe maximum length of the data type at the source DBMS, where a value of NULL indicates that length is not used.
source_precision_minbigintThe minimum precision of the data type at the source DBMS, where a value of NULL indicates that precision is not used.
source_precision_maxbigintThe maximum precision of the data type at the source DBMS, where a value of NULL indicates that precision is not used.
source_scale_minintThe minimum scale of the data type at the source DBMS, where a value of NULL indicates that scale is not used.
source_scale_maxintThe maximum scale of the data type at the source DBMS, where a value of NULL indicates that scale is not used.
source_nullablebitIndicated if the destination data type supports null values.
source_createparamsintInternal use only.
destination_dbmssysnameIndicates the name of the destination DBMS, and can be one of the following values:

 MSSQLSERVER = The destination is a SQL Server database.

 ORACLE = The destination is an Oracle database.

 DB2 = The destination is an IBM DB2 database.

 SYBASE = The destination is a Sybase database.
destination_versionsysnameThe product version of the destination DBMS.
destination_typesysnameThe data type in the destination DBMS.
destination_lengthbigintThe length of the data type in the destination DBMS.
destination_precisionbigintThe precision of the data type in the destination DBMS.
destination_scaleintThe scale of the data type in the destination DBMS.
destination_nullablebitIndicates if the data type in the destination DBMS supports a null value.
destination_createparamsintInternal use only.
datalossbitIndicates if data loss occurs when mapping between the data type at the source and destination DBMS.
is_defaultbitIndicates if the data type mapping is used by default.

Heterogeneous Database Replication
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)
sp_helpdatatypemap (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft