Show TOC

rs_dbsubsetsLocate this document in the navigation structure

Stores the name sets for database replication definitions. 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

prsid

int

Primary Replication Server ID

type

char

Item type:
  • T – table name.

  • F – function name.

  • X – transaction name.

  • P – system procedure name.

  • U – update command

  • L – delete command

  • I – insert select command

  • S – select into command

owner

varchar (30)

Owner name of a table or function, or the user name that executed a transaction or system procedure.

An * indicates all owners or users.

name

varchar (255)

Table, function, transaction, or system procedure name.

An * indicates all tables, functions, transactions, and system procedures.

status

int

Bitmask to indicate status of entries:
  • 0x01 – Materialization only

  • 0x02 – Add to the table list

  • 0x04 – Remove from the table list

  • 0x08 – Add to the exceptions list

  • 0x10 – Remove from the exceptions list

  • 0x20 – Last entry for this database replication definition

  • 0x40 – Update only for dbsubsets

priority

int

Priority of the table.

Indexes

Unique clustered index on (dbrepid, subtype, owner, name).