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

MSdbms_map (Transact-SQL)

 

Applies To: SQL Server

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 nameData typeDescription
map_idintUniquely identifies a data type mapping.
src_dbms_idintIdentifies the source DBMS by specifying its dbms_id in the MSdbms table.
dest_dbms_idintIdentifies the destination DBMS by specifying its dbms_id in the MSdbms table.
src_datatype_idintIdentifies the datatype_id from the MSdbms_datatype table for the source data type.
src_len_minbigintThe minimum length of the data type at the source DBMS, where a value of NULL indicates that length is not used.
src_len_maxbigintThe maximum length of the data type at the source DBMS, where a value of NULL indicates that length is not used.
src_prec_minbigintThe minimum precision of the data type at the source DBMS, where a value of NULL indicates that precision is not used.
src_prec_maxbigintThe maximum precision of the data type at the source DBMS, where a value of NULL indicates that precision is not used.
src_scale_minintThe minimum scale of the data type at the source DBMS, where a value of NULL indicates that scale is not used.
src_scale_maxintThe maximum scale of the data type at the source DBMS, where a value of NULL indicates that scale is not used.
src_nullablebitIndicates 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_idintIdentifies the default data type mapping by specifying its map_id in table MSdbms_datatype_mapping.

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