sys.sp_getdefaultdatatypemapping

Description

Returns information on the default mapping for the specified data type between SQL Server and a non-SQL Server database management system (DBMS). This stored procedure is executed at the Distributor on any database.

Syntax

sp_getdefaultdatatypemapping [ @source_dbms = ]
'source_dbms'
[ , [ @source_version = ]
'source_version'
]
, [ @source_type = ]
'source_type'
[ , [ @source_length = ] source_length ]
[ , [ @source_precision = ] source_precision ]
[ , [ @source_scale = ] source_scale ]
[ , [ @source_nullable = ] source_nullable ]
, [ @destination_dbms = ]
'destination_dbms'
[ , [ @destination_version = ]
'destination_version'
]
[ , [ @destination_type = ]
'destination_type'
OUTPUT
]
[ , [ @destination_length = ] destination_length
OUTPUT
]
[ , [ @destination_precision = ] destination_precision
OUTPUT
]
[ , [ @destination_scale = ] destination_scale
OUTPUT
]
[ , [ @destination_nullable = ] source_nullable
OUTPUT
]
[ , [ @dataloss = ] dataloss
OUTPUT
]
[ ; ]