rs_objects

prsid

int

Primary Replication Server where this object was created

objname

varchar(255)

Object name

objid

rs_id

Object ID

dbid

int

Unique ID for data server and database

objtype

char(1)

One of the following object types:

• R – table replication definition

• F – function replication definition

attributes

int

Mask, can be one or more of the following:

• 0x01 – Generate dynamic function strings

• 0x02 – Replication definition has fragments

• 0x04 – Minimum columns enabled for replication definition

• 0x08 – Replication definition has identity column

• 0x10 – replicate_if_changed status

• 0x20 – Replication definition has a drop pending

• 0x40 – Replication definition has text, unitext, or image column

• 0x80 – Replication definition is used by a standby

• 0x0100 – Replication definition’s columns are sent to standby database

• 0x0200 – Replication definition is propagated to Replication Servers Version 11.0.x or earlier

• 0x0400 – Replication definition has been used as a base replication definition for the primary table

• 0x0800 – Replication definition is internal only

• 0x1000 – Object or column names differ in the primary and replicate tables

• 0x4000 – replication definition has column-level translations

• 0x8000 – replication definition has columns declared with UDDs

ownertype

char(1)

Type of owner of this object:

• U – user

• S – System

crdate

datetime

Date and time created

parentid

rs_id

Reserved for future use.

ownerid

rs_id

ID of the user who created this object

rowtype

tinyint

1 if row is replicated, 0 if not

phys_tablename

varchar(255)

Primary table name – used when communicating with data server about this object

deliver_as_name

varchar(255)

Name of the replicate table or stored procedure

phys_objowner

char(30)

Name of the primary table owner, as specified in replication definition.

Blank if the table owner is not specified.

repl_obj_owner

char(30)

Name of the replicate table owner, as specified in replication definition.

Blank if the table owner is not specified.

has_baserepdef

rs_id

If this is not a base replication definition, the value of has_baserepdef matches that of objid for the base replication definition. Or, has the following value:

0x00 - Base replication definition

minvers

int

Specifies the minimum version of a replication definition, and thus the Replication Server to which it can propagate. Can be:

• 1200 – propagates to Replication Server version 12 or later

• 1150 – propagates to Replication Server version 11.5 or later

• 1000 or 0 (zero) – propagates to any Replication Server

• 0 (zero) – for function and system replication definitions