MSdbms_datatype (Transact-SQL)

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

The MSdbms_datatype table contains the complete list of native data types at each supported database management system (DBMS) used as either a Publisher or Subscriber in heterogeneous database replication. This table is stored in the msdb database.

Column name Data type Description
datatype_id int Identifies each unique data type.
dbms_id int Identifies the DBMS to which the type belongs.
type sysname Data type name (native).
createparams int Bitmap that describes what combination of length, precision, and scale is applicable to each data type, which includes:


0x2 = SCALE.

0x4 = LENGTH.


This table contains entries for SQL Server data types because an instance of SQL Server can both subscribe to a non-SQL Server database and publish to a non-SQL Server Subscriber.

See Also

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