sysdatatypemappings (Transact-SQL)
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 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:
|
||||||||||
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:
|
||||||||||
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)