MSdbms_datatype (Transact-SQL)
TOC
Collapse the table of content
Expand the table of content

MSdbms_datatype (Transact-SQL)

 

Applies To: SQL Server

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 nameData typeDescription
datatype_idintIdentifies each unique data type.
dbms_idintIdentifies the DBMS to which the type belongs.
typesysnameData type name (native).
createparamsintBitmap 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.

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

Community Additions

ADD
Show:
© 2016 Microsoft