Export (0) Print
Expand All

sysdatatypemappings (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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:

MSSQLSERVER = The source is a SQL Server database.

ORACLE = The 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:

MSSQLSERVER = The destination is a SQL Server database.

ORACLE = The destination is an Oracle database.

DB2 = The destination is an IBM DB2 database.

SYBASE = The 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft