MSdbms_map (Transact-SQL)

The MSdbms_map table contains source data type information as well as a link to default destination data type information for source and destination DBMS pairs. This table is stored in the msdb database and is used for heterogeneous publishing.

Column name

Data type

Description

map_id

int

Uniquely identifies a data type mapping.

src_dbms_id

int

Identifies the source DBMS by specifying its dbms_id in the MSdbms table.

dest_dbms_id

int

Identifies the destination DBMS by specifying its dbms_id in the MSdbms table.

src_datatype_id

int

Identifies the datatype_id from the MSdbms_datatype table for the source data type.

src_len_min

bigint

The minimum length of the data type at the source DBMS, where a value of NULL indicates that length is not used.

src_len_max

bigint

The maximum length of the data type at the source DBMS, where a value of NULL indicates that length is not used.

src_prec_min

bigint

The minimum precision of the data type at the source DBMS, where a value of NULL indicates that precision is not used.

src_prec_max

bigint

The maximum precision of the data type at the source DBMS, where a value of NULL indicates that precision is not used.

src_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.

src_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.

src_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.

default_datatype_mapping_id

int

Identifies the default data type mapping by specifying its map_id in table MSdbms_datatype_mapping.