Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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)