MSdbms_map (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.

See Also

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