Replicator User Guide > Replicator User Guide > A. Data Dictionary Tables > System Catalogs > dd_regist_tables Table
Was this helpful?
dd_regist_tables Table
The dd_regist_tables table shows the tables that have been registered with the local database:
Column Name
Data Type
Description
table_no
integer not null
Numeric identifier assigned to the table by the configuration process.
table_name
char(256) not null
The name of the user table.
table_owner
char(32) not null
The table owner’s user name.
columns_registered
char(25) not null with default
The last date and time the column or key registration was changed.
supp_objs_created
char(25) not null with default
The last date and time support objects were created.
rules_created
char(25) not null with default
The last date and time that change recording was activated.
cdds_no
smallint with null
Identifies the CDDS to which this table belongs.
cdds_lookup_table
char(256) not null with default
The name of the lookup table to be used for partitioning this table horizontally.
prio_lookup_table
char(256) not null with default
The name of the priority lookup table to be used for resolving collisions by priority.
index_used
char(256) not null with default
The name of the storage structure (primary or secondary index) containing the unique key columns used for replication.
Note:  If you rename any registered tables using the ALTER TABLE RENAME or RENAME TABLE statement, you must update dd_regist_tables with the new table names. Rename the tables in the replicated and target databases and then use the repmgr utility to register, support, and activate the new table names.
Last modified date: 08/28/2024