Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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:
|
||||||||||
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
Heterogeneous Database Replication