MSdbms (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

The MSdbms table contains a master list of all versions of the database management systems (DBMS) supported for heterogeneous database replication. This table is stored in the msdb database.

Column name Data type Description
dbms_id int Identifies each unique DBMS and version.
dbms sysname The DBMS name.

MSSQLSERVER

DB2

ORACLE

SYBASE
version varchar(10) The DBMS version.

See Also

Heterogeneous Database Replication
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)