MSdatatype_mappings (Transact-SQL)
Applies to:
SQL Server
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. Below are the possible values and their descriptions. 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. |
See Also
Heterogeneous Database Replication
Specify Data Type Mappings for an Oracle Publisher
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru