MSdbms_datatype_mapping (Transact-SQL)
Applies to: SQL Server
The MSdbms_datatype_mapping table contains the allowable data type mappings from the data type in the source database management system (DBMS) to one or more specific data types in the destination DBMS. This table is stored in the msdb database and is used for heterogeneous database replication.
Column name | Data type | Description |
---|---|---|
datatype_mapping_id | int | Identifies each unique data type mapping. |
map_id | int | Identifies the source data type. |
dest_datatype_id | int | Identifies the destination data type. |
dest_precision | bigint | Defines the precision of the destination data type, where a value of NULL means that precision is not used, and a value of -1 means that the precision of the source data type is used. |
dest_scale | int | Defines the scale of the destination data type, where a value of NULL means that scale is not used, and a value of -1 means that the scale of the source data type is used. |
dest_length | bigint | Defines the length of the destination data type, where a value of NULL means that length is not used, and a value of -1 means that the length of the source data type is used. |
dest_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. |
dest_createparams | int | The bitmap that describes what combination of length, precision, and scale are applicable for each data type, which includes: 0x1 = PRECISION. 0x2 = SCALE. 0x4 = LENGTH. |
See Also
Heterogeneous Database Replication
Specify Data Type Mappings for an Oracle Publisher
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)
Geri Bildirim
https://aka.ms/ContentUserFeedback.
Çok yakında: 2024 boyunca, içerik için geri bildirim mekanizması olarak GitHub Sorunları’nı kullanımdan kaldıracak ve yeni bir geri bildirim sistemiyle değiştireceğiz. Daha fazla bilgi için bkz.Gönderin ve geri bildirimi görüntüleyin