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:
0x1 = PRECISION.
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.