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 MSdbms_datatype table contains the complete list of native data types at each supported database management system (DBMS) used as either a Publisher or Subscriber in heterogeneous database replication. This table is stored in the msdb database.
Column name |
Data type |
Description |
|---|---|---|
datatype_id |
int |
Identifies each unique data type. |
dbms_id |
int |
Identifies the DBMS to which the type belongs. |
type |
sysname |
Data type name (native). |
createparams |
int |
Bitmap that describes what combination of length, precision, and scale is applicable to each data type, which includes: 0x1 = PRECISION. 0x2 = SCALE. 0x4 = LENGTH. |
Remarks
This table contains entries for SQL Server data types because an instance of SQL Server can both subscribe to a non-SQL Server database and publish to a non-SQL Server Subscriber.
See Also
Reference
Replication Views (Transact-SQL)
Concepts
Heterogeneous Database Replication