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:
| ||
|
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. |
Reference
Replication Views (Transact-SQL)sp_helpdatatypemap (Transact-SQL)
