MSdbms_datatype_mapping (Transact-SQL)
TOC
Collapse the table of content
Expand the table of content

MSdbms_datatype_mapping (Transact-SQL)

 

Applies To: SQL Server

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 nameData typeDescription
datatype_mapping_idintIdentifies each unique data type mapping.
map_idintIdentifies the source data type.
dest_datatype_idintIdentifies the destination data type.
dest_precisionbigintDefines 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_scaleintDefines 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_lengthbigintDefines 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_nullablebitIndicates whether the destination column in the mapping allows NULL values, where a value of NULL means that this definition is not required.
dest_createparamsintThe bitmap that describes what combination of length, precision, and scale are applicable for each data type, which includes:

 0x1 = PRECISION.

 0x2 = SCALE.

 0x4 = LENGTH.

Heterogeneous Database Replication
Specify Data Type Mappings for an Oracle Publisher
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft