A. Data Dictionary Tables : System Catalogs : dd_regist_tables Table
 
Share this page                  
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.