MSdbms (Transact-SQL)

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

Reference

Replication Views (Transact-SQL)

Concepts

Heterogeneous Database Replication

Replication Tables (Transact-SQL)