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 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)