MSdbms_datatype (Transact-SQL)
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. |
