Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

MSdbms_datatype_mapping (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 MSdbms_datatype_mapping table contains the allowable data type mappings from the data type in the source database management system (DBMS) to one or more specific data types in the destination DBMS. This table is stored in the msdb database and is used for heterogeneous database replication.

Column name

Data type

Description

datatype_mapping_id

int

Identifies each unique data type mapping.

map_id

int

Identifies the source data type.

dest_datatype_id

int

Identifies the destination data type.

dest_precision

bigint

Defines the precision of the destination data type, where a value of NULL means that precision is not used, and a value of -1 means that the precision of the source data type is used.

dest_scale

int

Defines the scale of the destination data type, where a value of NULL means that scale is not used, and a value of -1 means that the scale of the source data type is used.

dest_length

bigint

Defines the length of the destination data type, where a value of NULL means that length is not used, and a value of -1 means that the length of the source data type is used.

dest_nullable

bit

Indicates whether the destination column in the mapping allows NULL values, where a value of NULL means that this definition is not required.

dest_createparams

int

The bitmap that describes what combination of length, precision, and scale are applicable for each data type, which includes:

0x1 = PRECISION.

0x2 = SCALE.

0x4 = LENGTH.

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

Community Additions

ADD
Show:
© 2015 Microsoft