rs_columns

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

• 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 the following:

• 0x01 – column is declared an identity 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

• 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.