A. System Catalogs : Standard Catalog Interface : Standard Catalogs for All Databases : iitables Catalog
 
Share this page                  
iitables Catalog
The iitables catalog contains an entry for each table, view, or index in the database.
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
The following columns have values only if the table_type is T, I, or P. Enterprise Access products that do not supply this information:
Numeric columns are set to -1
Character columns are set to blank.
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.
The following columns are used by the DBMS Server, except for those preceded by an asterisk (*).
Columns preceded by an asterisk (*) have values only if table_type is T or I.
Where Enterprise Access entries do not supply this information:
Numeric columns are set to -1
Character columns are set to blank
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)
Y if object is a base for a view definition
N if not
Blank if unknown
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)