Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSdatatype_mappings (Transact-SQL)

MSdatatype_mappings (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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

MSSQLSERVER

The destination is a SQL Server database.

ORACLE

The destination is an Oracle database.

DB2

The destination is an IBM DB2 database.

SYBASE

The 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.

Community Additions

ADD
Show:
© 2015 Microsoft