rs_objects

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 these: 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`	`varchar(30)`	Name of the primary table owner, as specified in replication definition. Blank if the table owner is not specified.
`repl_objowner`	`varchar(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.

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)