rs_objects

Description

Stores replication definitions, one per row.

Column	Datatype	Description
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 bigdatetime or bigtime columns and can be propagated only to Replication Server 15.5 or later. 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. 0x10000 – replication definition has char, varchar, binary, or varbinary columns with more than 255 bytes and can be propagated only to Replication Server 12.5 or later. 0x20000 – replication definition has unichar or univarchar columns and can be propagated only to Replication Server 12.5 or later. 0x40000 – replication definition has date or time columns and can be propagated only to Replication Server 12.6 or later. 0x80000 – replication definition has timestamp columns. Propagated to Replication Server 15.1 as timestamp, and propagated to Replication Server 15.0.1 or earlier as varbinary. 0x200000 – applied function replication definition and can be propagated only to Replication Server 15.1. 0x400000 – request function replication definition and can be propagated only to Replication Server 15.1. 0x800000 – dynamic SQL is not used on the table. 0x2000000 - update is enabled for SQL replication. 0x4000000 - delete is enabled for SQL replication. 0x8000000 - insert select is enabled for SQL replication 0x10000000 - SQL replication is disabled by repserver internally
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_objowner	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
version	rs_id	Uniquely identifies a replication definition version.
active_inbound	int	Executor uses this column to decide which replication definition version to use. Executor uses the replication definition version whose value for the active_inbound column is 0.
attributes2	int	0x01 – Distributor uses this to identify replication definition versions which are not in use by Distributor. 0x02 – The standby DSI uses this to identify replication definition versions which are not in use by the standby DSI.

Replication Server may create a new replication definition version when you alter a replication definition. When that happens, Replication Server changes the name of the old replication definition version to a unique name with a “rs_drp” prefix. Replication Server treats replication definitions with names prefixed with “rs_drp” or “rs_in” as internal replication definitions.

Replication Server deletes an internal replication definition when the data associated with the replication definition is no longer in the replication system.

To exclude internal replication definitions from a query to the rs_objects table, add to the where clause of the query:

and objname not like ‘rs_drp%’ and objname not like
‘rs_in%’

For example, this query returns the name of all replication definitions created against the ling.authors primary table, and excludes the internal replication definitions:

select objname from rs_objects where prsid = 16777317
and dbid = 104 and phys_tablename = 'authors' and
phys_objowner = 'ling' and objname not like 'rs_drp%'
and objname not like 'rs_in%

Indexes

Unique clustered index on (objname)
Unique index on (dbid, phys_tablename, phys_objowner, objtype, has_baserepdef, active_inbound)
Unique index on (objid)
Unique index on (version)