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)

N if a view never existed on this table
Y if at least one view existed for this table or all views on this table are dropped

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