Column Name | Data Type | Description |
table_name | char(256) | The name of the table |
table_owner | char(32) | The owner of the table |
create_date | char(25) | The creation date of the object Blank if unknown |
alter_date | char(25) | The last time this table was altered. Updated when the structure of the table changes through changes to the columns in the table or to the primary key. Physical changes to the table, such as changes to data, secondary indexes, or physical keys, do not change this date. Blank if unknown. |
table_type | char(1) | Type of the query object: T if table V if view I if index P if physical partition of a partitioned table Further information about views can be found in iiviews. |
table_subtype | char(1) | Specifies the type of table or view. N if native for standard Ingres databases L if links for Star I if imported tables for Enterprise Access Blank if unknown |
table_version | varchar(11) | Version of the object; enables the Ingres tools to determine where additional information about this particular object is stored. This reflects the database type, as well as the version of an object in a given database. For Ingres tables, the value for this field is II9.0. |
system_use | char(1) | S if the object is a system object U if user object G if generated by the system for the user Blank if unknown |
tups_per_page | integer | Maximum tuples per data page |
keys_per_page | integer | Maximum keys per index page for ISAM and BTREE tables |
keys_per_leaf | integer | Maximum keys per leaf for BTREE tables |
Column Name | Data Type | Description |
table_stats | char(1) | Y if the iistats table has entries N if the iistats table does not have entries Blank if query iistats to determine if statistics exist. |
table_indexes | char(1) | Y if this object has entries in iiindexes that see this as a base table N if this object does not have entries Blank if query iiindexes on the base_table column |
is_readonly | char(1) | N if updates are allowed Y if no updates are allowed Blank if unknown Used for tables defined to Enterprise Access for retrieval only (such as tables in a hierarchical database). If Y updates cannot occur, irrespective of the permissions set If N updates are allowed depending on the permissions setting |
concurrent_access | char(1) | Y if concurrent access is allowed |
num_rows | integer | The estimated number of rows in the table -1 if unknown If value is for a partitioned table, this is the total for all partitions |
storage_structure | char(16) | The storage structure of the table: HEAP HASH BTREE ISAM |
is_compressed | char(1) | Y if the table is compressed N if the table is uncompressed Blank if unknown |
key_is_compressed | char(1) | Y if the table uses key compression N if no key compression Blank if unknown |
duplicate_rows | char(1) | D if the table allows duplicate rows U if the table does not allow duplicate rows Blank if unknown The table storage structure (unique vs. non-unique keys) can override this setting. |
unique_rule | char(1) | D if duplicate keys are allowed. (A unique alternate key exists in iialt_columns and any storage structure keys are listed in iicolumns.) U if the object is an Ingres object, indicates that the object has unique storage structure keys. If the object is not an Ingres object, it indicates that the object has a unique key, described in either iicolumns or iialt_columns. Blank if uniqueness is unknown or does not apply. |
number_pages | integer | The estimated number of used pages in the table -1 if unknown If the value is for a partitioned table, this is the total for all partitions. |
overflow_pages | integer | The estimated number of overflow pages in the table -1 if unknown |
partition_dimensions | smalliint | For a partitioned table, this is the number of dimensions (partitioning levels) in the table's partitioning scheme. In all other cases, this is zero. |
phys_partitions | smallint | For a partitioned table, this is the number of physical partitions. For a physical partition, this is the partition number In all other cases, this is zero. |
row_width | integer | The size in bytes of the uncompressed binary value for a row of this query object. For encrypted tables, the width of the encrypted row. |
Column Name | Data Type | Description |
expire_date | integer | Expiration date of table |
modify_date | char(25) | The date when the table was last modified Blank if unknown or inapplicable |
location_name | char(32) | The first location of the table. If there are additional locations for a table, they are shown in the iimulti_locations table and multi_locations are set to Y. |
table_integrities | char(1) | Y if this object has Ingres style integrities Blank if query the iiintegrities table to determine if integrities exist |
table_permits | char(1) | Y if this object has Ingres style permissions |
all_to_all | char(1) | Y if this object has Ingres permit all to all N if not |
ret_to_all | char(1) | Y if this object has Ingres permit retrieve to all N if not |
is_journalled | char(1) | Y if journaling is enabled on this object N if journaling is disabled on this object C if journaling is enabled/disabled after the next online checkpoint |
view_base | char(1) | Deprecated. Value set to N. |
multi_locations | char(1) | Y if the table is in multiple locations N if the table is single location |
table_ifillpct | smallint | Fill factor, expressed as a percentage, for the index pages Specified in modify command nonleaffill clause |
table_dfillpct | smallint | Fill factor, expressed as a percentage, for the data pages Specified in modify command fillfactor clause |
table_lfillpct | smallint | Fill factor, expressed as a percentage, for the leaf pages Specified in modify command leaffill clause |
table_minpages | integer | Minpages parameter from the last execution of the modify command. Used for hash structures only. |
table_maxpages | integer | Maxpages parameter from the last execution of the modify command. Used for hash structures only. |
table_relstamp1 | integer | High part of last create or modify timestamp for the table |
table_relstamp2 | integer | Low part of last create or modify timestamp for the table |
table_reltid | integer | Reltid from iirelation |
table_reltidx | integer | Reltidx from iirelation |
* unique_scope | char(1) | R if this object is row-level S if statement-level Blank if not applicable |
* allocation_size | integer | The allocation size, in pages. Set to -1 if unknown. |
* extend_size | integer | The extend size, in pages -1 if unknown |
* allocated_pages | integer | The total number of pages allocated to the table |
row_security_audit | char(1) | Y if row-level security auditing is enabled N if not |
table_pagesize | integer | Page size of a table |
table_relversion | smallint | Version of table |
table_reltotwid | integer | Width of the table, including all deleted columns. For encrypted tables, the width of the encrypted row. |
table_reltcpri | smallint | Indicates a table's priority in the buffer cache Values can be between 0 - 8: Zero is the default. 1 - 8 can be specified in the priority clause of a create table or modify table statement. |
label_granularity | char(1) | Empty string This column is deprecated. |
security_label | char(8) | Empty string This column is deprecated. |
table_reldatawid | integer | The size in bytes of the uncompressed binary value for a row of this query object (for encrypted tables, the width of the decrypted row) |
table_reltotdatawid | integer | Width of the table, including all deleted columns (for encrypted tables, the width of the decrypted row) |
encrypted_columns | char(1) | Y if the table contains encrypted columns N if not |
encryption_version | smallint | Internal version number of column encryption for the table (0 if there is no encryption) |
encryption_type | varchar | Column encryption type (NONE, AES128, AES192, or AES256) |