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.