Share via


MSdatatype_mappings (Transact-SQL)

The MSdatatype_mappings view maps SQL Server data types to data types used by non-SQL Server database management systems (DBMS). This table is stored in the msdb database.

Column name

Data type

Description

dbms_name

nvarchar(128)

Is the name of the DBMS, and can be one of the following values:

Value

Description

MSSQLSERVERThe destination is a SQL Server database.

ORACLEThe destination is an Oracle database.

DB2The destination is an IBM DB2 database.

SYBASEThe destination is a Sybase database.

sql_type

nvarchar(128)

Is the SQL Server data type.

dest_type

nvarchar(128)

Is the name of the non-SQL Server data type.

dest_prec

bigint

Is the precision of the non-SQL Server data type.

dest_create_params

int

Internal use only.

dest_nullable

bit

Is if the non-SQL Server data type supports a NULL value.

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