rs_dbreps

Stores all information about database replication definitions except name sets. It is replicated to all sites with a version number of 12.6 or later.

Column

Datatype

Description

dbrepid

rs_id

Database replication definition ID

dbrepname

varchar (255)

Database replication definition name

prsid

int

Primary Replication Server ID

dbid

int

Primary database ID

ownerid

rs_id

Replication Server user who created the database replication definition

requestdata

datetime

Time the database replication definition was created

status

int

Bitmap of subset content:
  • 0x0001 – table list appears

  • 0x0002 – tables are negated

  • 0x0004 – function list appears

  • 0x0008 – functions are negated

  • 0x0010 – transaction list appears

  • 0x0020 – transactions are negated

  • 0x0040 – system procedure list appears

  • 0x0080 – system procedure is negated

  • 0x0100 – do not replicate DDL

  • 0x0200 – update list appears

  • 0x0400 – update statement replication is negated for the list

  • 0x0800 – delete list appears

  • 0x1000 – delete statement replication is negated for the list

  • 0x2000 – select into list appears

  • 0x4000 – select into statement replication is negated for the list

  • 0x8000 – insert select list appears

  • 0x10000 – insert select statement replication is negated for the list

minvers

int

Earliest version of Replication Server to which this table can be replicated.

Indexes

Unique indexes on (dbrepid, dbid, and dbrepname).