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 |