rs_dependtbls

Stores tables that are pending to add or remove from database replication definitions.

Column

Datatype

Description

dbrepid

rs_id

The replication definition ID that table in this row is pending for.

dbsubid

rs_id

The subscription ID that table in this row is pending for.

owner

varchar(30)

Name of the table owner.

name

varchar(255)

Name of the table.

repdb

int

Name of the replicate database.

primdb

int

Name of the primary database.

status

int

Status flag:
  • 0x01 – new request
  • 0x02 – request in progress
  • 0x03 – error processing request

action

int

A flag indicating current action for the table:
  • 0x01 – waiting
  • 0x02 – adding
  • 0x03 – removing

request

int

A flag indicating requested action for the table:
  • 0x01 – add table
  • 0x02 – remove table
  • 0x03 – rematerialize table

Indexes

Unique clustered index on (dbsubid, owner, name).