Share via


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.

Remarks

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

Reference

Replication Views (Transact-SQL)

Concepts

Replication Tables (Transact-SQL)

Other Resources

Heterogeneous Database Replication
How to: Specify Data Type Mappings for an Oracle Publisher (Replication Transact-SQL Programming)

Help and Information

Getting SQL Server 2005 Assistance