rs_columns

Contains information about the columns of replication definitions.

Column	Datatype	Description
`prsid`	`int`	Primary Replication Server for this object
`objid`	`rs_id`	Table/function replication definition ID or function ID this column belongs to
`colname`	`varchar(255)`	Column or parameter name
`colnum`	`smallint`	Column number
`coltype`	`tinyint`	Datatype of the column or parameter: 0 – `char` 1– `binary` 4 – `text` 5 – `image` 6 – `tinyint` 7 – `smallint` 8 – `int` 9 – `real` 10 – `float` 11 – `bit` 12 – `datetime` 13 – `smalldatetime` 14 – `money` 15 – `smallmoney` 16 – `numeric` 17 – `decimal` 18 – `varchar` 19 – `varbinary` 25 – `unichar` 27 – `date` 28 – `time` 29 – `unitext` 30 – `bigint` 31 – `usmallint` 32 – `uint` 33 – `ubigint` 35 – `bigdatetime` 36 – `bigtime` 110 – `univarchar`
`length`	`int`	Length of the declared data
`searchable`	`tinyint`	1 if searchable key, 0 if not
`primary_col`	`tinyint`	1 if primary key, 0 if not
`fragmentation`	`tinyint`	1 if fragmentation key, 0 if not
`rowtype`	`tinyint`	1 if row is to be replicated, 0 if not
`status`	`int`	Mask, can be one or more of these: 0x01 – column is declared an `<identity>` column 0x02 – column is declared a `<timestamp>` column 0x04 – column is an `<rs_address>` datatype 0x08 – column has a status of replicate_if_changed 0x10 – column allows null values in the replicate table (only for `<text>`, `<unitext>`, or `<image>` columns) 0x20 – column is sent to standby connection (only in internal replication definitions) 0x40 – column is marked as dropped from the internal replication definition (only in internal replication definitions) 0x200 – published as `<identity>` 0x400 – published as `<timestamp>` 0x1000 – declared as Java column 0x2000 – published as Java column
`basecolnum`	`smallint`	Column position in base replication definition. Default is `<colnum>` value.
`repl_colname`	`char(255)`	Column name in replicate table. Default is `<colname>` value.
`declared_dtid`	`rs_id`	Datatype ID. For a user-defined datatype, this is a foreign key to the table.
`publ_dtid`	`rs_id`	Published datatype as specified in the replication definition. If no published datatype is specified, `publ_dtid` is equal to `declared_dtid`.
`publ_base_coltype`	`tinyint`	The base datatype of the published datatype. If no published datatype is specified, `publ_base_coltype` is equal to `coltype`.
`publ_length`	`int`	The maximum length of the published datatype.
`version`	`rs_id`	Identifies a replication definition version.
`ref_objowner`	`varchar(30)`	The replicate object owner identified by the references clause and used for RI constraints. The object owner is the table owner at the replicate database identified for a RI constraint.
`ref_objname`	`varchar(255`)	The replicate object name identified by the references clause and used for the RI constraints. The object name is the table name at the replicate database identified for a RI constraint.

Indexes

Unique clustered index on (version, colname)
Unique index on (objid, basecolnum)
Unique index on (objid, colname)
Unique index on (objid, colnum)
Unique index on (version, colnum)