sysdatatypemappings (Transact-SQL)
The sysdatatypemappings view is used 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 name
Data type
Description
mapping_id
int
The ID of the data type mapping.
source_dbms
sysname
Indicates the name of the DBMS from which the data types are mapped, and can be one of the following values:
Value
Description
MSSQLSERVERThe source is a SQL Server database.
ORACLEThe source is an Oracle database.
source_version
sysname
Indicates the product version of the source DBMS.
source_type
sysname
Indicates the data type listed in the source DBMS.
source_length_min
bigint
The minimum length of the data type at the source DBMS, where a value of NULL indicates that length is not used.
source_length_max
bigint
The maximum length of the data type at the source DBMS, where a value of NULL indicates that length is not used.
source_precision_min
bigint
The minimum precision of the data type at the source DBMS, where a value of NULL indicates that precision is not used.
source_precision_max
bigint
The maximum precision of the data type at the source DBMS, where a value of NULL indicates that precision is not used.
source_scale_min
int
The minimum scale of the data type at the source DBMS, where a value of NULL indicates that scale is not used.
source_scale_max
int
The maximum scale of the data type at the source DBMS, where a value of NULL indicates that scale is not used.
source_nullable
bit
Indicated if the destination data type supports null values.
source_createparams
int
Internal use only.
destination_dbms
sysname
Indicates the name of the destination DBMS, and can be one of the following values:
Value
Description
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.
destination_version
sysname
The product version of the destination DBMS.
destination_type
sysname
The data type in the destination DBMS.
destination_length
bigint
The length of the data type in the destination DBMS.
destination_precision
bigint
The precision of the data type in the destination DBMS.
destination_scale
int
The scale of the data type in the destination DBMS.
destination_nullable
bit
Indicates if the data type in the destination DBMS supports a null value.
destination_createparams
int
Internal use only.
dataloss
bit
Indicates if data loss occurs when mapping between the data type at the source and destination DBMS.
is_default
bit
Indicates if the data type mapping is used by default.
See Also
Reference
Replication Views (Transact-SQL)
sp_helpdatatypemap (Transact-SQL)
Concepts
Replication Tables (Transact-SQL)
Other Resources
Heterogeneous Database Replication