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:
ValueDescription
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:
ValueDescription
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. |