MSdbms_datatype (Transact-SQL)
Applies to: SQL Server
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
Heterogeneous Database Replication
Specify Data Type Mappings for an Oracle Publisher
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)
Feedback
https://aka.ms/ContentUserFeedback.
Binnenkort beschikbaar: In de loop van 2024 zullen we GitHub-problemen geleidelijk uitfaseren als het feedbackmechanisme voor inhoud en deze vervangen door een nieuw feedbacksysteem. Zie voor meer informatie:Feedback verzenden en weergeven voor