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)

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

Blank if the owner is not specified.

ref_objname

varchar(255)

Object name defined in the replicate database.

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)