Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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