A. System Catalogs : Standard Catalog Interface : Standard Catalogs for All Databases : iiingres_tables Catalog
 
Share this page                  
iiingres_tables Catalog
The iiingres_table catalog presents information about tables, views, and indexes in a different format than iitables.
Column Name
Data Type
Description
table_name
char(256)
The name of the table
table_owner
char(32)
The owner of the table
expire_date
char(25)
How long to save this table
A value of 1970_01_01 00:00:00 GMT indicates table never expires.
table_integrities
char(1)
Y if integrities exist on this table
N if not
table_permits
char(1)
Y if permits exist on this table
N if not
all_to_all
char(1)
Y if any user can perform any operation on this table
N if not
ret_to_all
char(1)
Y if any user can retrieve data from this table
row_width
integer
Maximum width of tuple in bytes
is_journalled
char(1)
N if not journaled
Y if journaled.
C if journaled started/stopped after next checkpoint
view_base
char(1)
Deprecated. Value set to N.
modify_date
char(25)
Date of last modify performed on the table
If never modified, the table creation date
table_ifillpct
smallint
Fill factor for B-tree index pages
Otherwise unused
table_dfillpct
smallint
Fill factor for data pages if table does not have HEAP structure
table_lfillpct
smallint
Fill factor for B-tree leaf pages
table_minpages
integer
Minimum number of hash buckets to use if modifying to HASH structure
table_maxpages
integer
Maximum number of hash buckets to use if modifying to HASH structure
location_name
char(32)
Name of first location for data files
table_reltid
integer
Reltid from iirelation
table_reltidx
integer
Reltidx from iirelation