Stores replication definitions, one per row.
Column
|
Datatype
|
Description
|
|---|
prsid
|
int
|
Primary Replication Server
where this object was created
|
objname
|
varchar(255)
|
Object name
|
objid
|
rs_id
|
Object ID
|
dbid
|
int
|
Unique ID for data server
and database
|
objtype
|
char(1)
|
One of the following object
types:
|
attributes
|
int
|
Mask, can be one or more
of the following:
0x01 – generate dynamic function
strings.
0x02 – replication definition has fragments.
0x04 – minimum columns enabled for replication
definition.
0x08 – replication definition has identity column.
0x10 – replicate_if_changed status.
0x20 – replication definition has a drop
pending.
0x40 – replication definition has text, unitext,
or image column.
0x80 – replication definition is used by
a standby.
0x0100 – replication definition’s
columns are sent to standby database.
0x0200 – replication definition is propagated
to Replication Servers version 11.0.x or earlier.
0x0400 – replication definition has been
used as a base replication definition for the primary table.
0x0800 – replication definition is internal
only.
0x1000 – object or column names differ
in the primary and replicate tables.
0x4000 – replication definition has column-level
translations.
0x8000 – replication definition has columns
declared with UDDs.
|
|
|
0x10000 – replication
definition has char, varchar, binary,
or varbinary columns with more than 255 bytes
and can be propagated only to Replication Server 12.5 or later.
0x20000 – replication definition has unichar or univarchar columns
and can be propagated only to Replication Server 12.5 or later.
0x40000 – replication definition has date or time columns
and can be propagated only to Replication Server 12.6 or later.
0x80000 – replication
definition has timestamp columns. Propagated
to Replication Server 15.1 as timestamp, and
propagated to Replication Server 15.0.1 or earlier as varbinary.
0x200000 – applied function replication
definition and can be propagated only to Replication Server 15.1.
0x400000 – request function replication
definition and can be propagated only to Replication Server 15.1.
0x800000 – dynamic SQL is not used on the
table.
0x2000000 - update is enabled
for SQL replication.
0x4000000 - delete is enabled
for SQL replication.
0x8000000 - insert select is
enabled for SQL replication.
0x10000000 - SQL replication is disabled by repserver
internally.
|
ownertype
|
char(1)
|
Type of owner of this
object:
|
crdate
|
datetime
|
Date and time created
|
parentid
|
rs_id
|
Reserved for future use.
|
ownerid
|
rs_id
|
ID of the user who created
this object
|
rowtype
|
tinyint
|
1 if row is replicated,
0 if not
|
phys_tablename
|
varchar(255)
|
Primary table name – used
when communicating with data server about this object
|
deliver_as_name
|
varchar(255)
|
Name of the replicate
table or stored procedure
|
phys_objowner
|
char(30)
|
Name of the primary table
owner, as specified in replication definition.
Blank if the table owner is not specified.
|
repl_objowner
|
char(30)
|
Name of the replicate
table owner, as specified in replication definition.
Blank if the table owner is not specified.
|
has_baserepdef
|
rs_id
|
If this is not a base
replication definition, the value of has_baserepdef matches
that of objid for the base replication definition.
Or, has the following value:
0x00 - Base replication definition
|
minvers
|
int
|
Specifies the minimum version of a replication
definition, and thus the Replication Server to which it can propagate.
Can be:
1200 – propagates to Replication
Server version 12 or later
1150 – propagates to Replication Server
version 11.5 or later
1000 or 0 (zero) – propagates to any Replication
Server
0 (zero) – for function and system replication
definitions
|
