TTREP.REPTABLES

The REPTABLES table contains subscriber-relative information about each of the columns in each table transmitted to a subscriber. This information appears in REPTABLES in the owner (transmitter) database but not in REPTABLES in the subscriber database.

Columns

Column name	Type	Description
REPLICATION_NAME	TT_CHAR(31) NOT NULL	Name for a replication scheme
REPLICATION_OWNER	TT_CHAR(31) NOT NULL	The replication scheme's owner
ELEMENT_NAME	TT_CHAR(31) NOT NULL	The replication name for this element, logically different from the REF_NAME of the underlying data base object For example, the ELEMENT_NAME for a replicated table may differ from the table name. This name must be unique in a replication scheme.
SUBSCRIBER_ID	TT_BIGINT NOT NULL	The TT_STORE_ID for a subscriber to this element A subscriber may not subscribe more than once to a replication element in a replication scheme.
COLNUM	TT_SMALLINT NOT NULL	Ordinal number of column in table (starting at 1)
COLOPTIONS	BINARY(1) NOT NULL	Column specification flags 0x01 - Column is in a primary key. 0x02 - Column value is varying length data type (VARCHAR[2], NVARCHAR[2], VARBINARY). 0x04 - Column value can be NULL. 0x08 - Column values are unique.
COLTYPE	TT_INTEGER NOT NULL	Data type of column  1     TT_CHAR  4     TT_INTEGER  5     TT_SMALLINT  6     BINARY_FLOAT  7     BINARY_FLOAT  8     BINARY_DOUBLE  9     TT_DATE 10     TIME 11     TT_TIMESTAMP 12     TT_VARCHAR 13     DATE 14     TIMESTAMP 15     NUMBER 16     CHAR 17     VARCHAR2 18     NCHAR 19     NVARCHAR2 - 1     LONGVARCHAR - 2     BINARY - 3     VARBINARY - 4     LONGVARBINARY - 5     TT_BIGINT - 6     TT_TINYINT - 7     BIT - 8     WCHAR - 9     WVARCHAR - 10   WLONGVARCHAR
COLLEN	TT_BIGINT NOT NULL	Length of the column (maximum length for varying-length columns)
COLPRECISION	TT_INTEGER NOT NULL	Precision of column data This is the number of digits in a fixed-point number, or the number of digits in the mantissa of a floating point number.
COLSCALE	TT_INTEGER NOT NULL	Scale of column data (non-negative number) A scale of 0 indicates an integer with no digits to the right of a decimal point. For a scale of S, the exact numeric value is the integer value of the significant digits multiplied by: 10 (exp -S).
PTNNUM	TT_SMALLINT NOT NULL	The table partition that contains the column
PTNCOLOFF	TT_BIGINT NOT NULL	The offset of the column within the partition
PTNNULLOFF	TT_BIGINT NOT NULL	The offset to the null byte within the partition
REPKEYPOSITION	TT_SMALLINT NOT NULL	The ordinal position of this column in the replication key described by the REPKEYCOLS
TS_EXCEPTION_ACTION	TT_CHAR(1) NOT NULL	The action to take upon detecting a conflict by a timestamp-based detector The action is specified by the ON EXCEPTION clause in the CHECK CONFLICTS of a CREATE REPLICATION statement. They appear in this column as: \0' - Undefined action 'N' - NO ACTION 'R' - ROLLBACK (default)
PNBOFF	TT_INTEGER	For internal use only
NULLMASK	TT_TINYINT	For internal use only
COLNAME	TT_CHAR(31)	Column name