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