Column Name | Data Type | Description |
|---|---|---|
table_name | char(256) | The object’s name. Must be a valid name. |
table_owner | char(32) | The object’s owner. Must be a valid username. Generally, the creator of the object is the owner. |
create_date | char(25) | The object’s creation date. Blank if unknown. This is a date field. |
alter_date | char(25) | The last time this table was altered. This date is updated whenever the logical structure of the table changes, either through changes to the columns in the table or changes 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. This is a date field. |
table_type | char(8) | Type of the query object: T table V view I index Further information about tables can be found in iiphysical_tables; further information about views can be found in iiviews. |
table_subtype | char(8) | Specifies the type of table or view. Possible values are: N (native) for Ingres Star-level table (created by create table or create view statement issued from Ingres Star) L (links) for Ingres Star “ ” (blank) if unknown |
table_version | char(8) | Version of the object; enables the 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 within a given database. For tables, the value for this field is ING6.0. |
system_use | char(8) | Contains S if the object is a system object, U if user object, or blank if unknown. Used by utilities to determine which tables need reloading. If the value is unknown, the utilities will use the naming convention of ii for tables in order to distinguish between system and user catalogs. Also, any table beginning with ii_ is assumed to be a tool object, rather than a DBMS system object. The system catalogs themselves must be included in the iitables catalog and are considered system tables. |
Column Name | Data Type | Description |
|---|---|---|
table_stats | char(8) | Y if this object has entries in the iistats table, N if this object does not have entries. If this field is blank, then you must query iistats to determine if statistics exist. This column is used only for optimization of databases. |
table_indexes | char(8) | Y if this object has entries in the iiindexes table that refer to this as a base table, or N if this object does not have entries. If the field is blank, then you must query iiindexes on the base_table column. This field is used only for optimization of databases. |
is_readonly | char(8) | N if updates are physically allowed, Y if no updates are allowed, or blank if unknown. Used for tables that are defined to the Enterprise Access only for retrieval, such as tables in hierarchical database systems. If this field is set to Y then no updates will work, independent of what permissions might be set. If it is set to N, updates may be allowed, depending on whether the permissions allow it or not. |
num_rows | integer | The estimated number of rows in the table. Set to -1 if unknown. |
storage_structure | char(16) | The storage structure for the table: heap, hash, B-tree, or isam. Blank if the table structure is unknown. |
is_compressed | char(8) | Y if the table is stored in compressed format, N if the table is uncompressed, blank if unknown. |
duplicate_rows | char(8) | 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(8) | The value may be U (unique key), D (duplicate key) or blank if unknown or does not apply. D indicates that duplicate physical storage structure keys are allowed. (A unique alternate key may exist in iialt_columns and any storage structure keys may be listed in iicolumns.) U: If the object is an Ingres object, indicates that the object has a unique storage structure key(s); if the object is not an Ingres object, then it indicates that the object has a unique key, described in either iicolumns or iialt_columns. |
number_pages | integer | The estimated number of physical pages in the table. Set to -1 if unknown. |
overflow_pages | integer | The estimated number of overflow pages in the table. Set to -1 if unknown. |
row_width | integer | The size, in bytes, of the uncompressed binary value for a row of this query object. |
Column Name | Data Type | Description |
|---|---|---|
expire_date | integer | Expiration date of table. This is a _bintime date. |
modify_date | char(25) | The date on which the last physical modification to the storage structure of the table occurred. Blank if unknown or inapplicable. This is a date field. |
location_name | char(32) | The first location of the table. If there are additional locations for a table, they will be shown in the iimulti_locations table and multi_locations will be set to Y. |
table_integrities | char(8) | Y if this object has Ingres-style integrities. If the value is blank, you must query the iiintegrities table to determine if integrities exist. |
table_permits | char(8) | Y if this object has Ingres-style permissions. |
all_to_all | char(8) | Y if this object has permit all to all, N if not. |
ret_to_all | char(8) | Y if this object has permit retrieve to all, N if not. |
is_journalled | char(8) | Y if journaling is enabled on this object, N if not. Set to C if journaling will be enabled at the next checkpoint. This will be blank if journaling does not apply. |
view_base | char(8) | Deprecated. Value set to N. |
multi_locations | char(8) | Y if the table is in multiple locations, N if not. |
table_ifillpct | smallint | Fill factor for the index pages used on the last modify statement in the nonleaffill clause, expressed as a percentage (0 to 100). Used for B-tree structures in order to rerun the last modify statement. |
table_dfillpct | smallint | Fill factor for the data pages used on the last modify statement in the fillfactor clause, expressed as a percentage (0 to 100). Used for B-tree, hash, and isam structures in order to rerun the last modify statement. |
table_lfillpct | smallint | Fill factor for the leaf pages used on the last modify statement in the leaffill clause, expressed as a percentage (0 to 100). Used for B-tree structures in order to rerun the last modify statement. |
table_minpages | integer | Minpages parameter from the last execution of the modify statement. Used for hash structures only. |
table_maxpages | integer | Maxpages parameter from the last execution of the modify statement. 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 | The first part of the internal relation ID. |
table_reltidx | integer | The second part of the internal relation ID. |