MSdbms (Transact-SQL)

Applies to: SQL Server

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)