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