Was this helpful?
iiphysical_tables Catalog
The information in the iiphysical_tables catalog overlaps with some of the information in iitables. This information is provided as a separate catalog primarily for use by Enterprise Access products. Query the physical_source column, in iidbcapabilities, to determine whether you must query iiphysical_tables. If you do not want to query iidbcapabilities, then you must always query iiphysical_tables to be sure of getting the correct information.
If a queryable object is type T or I (for index, in an Ingres installation only), then it is a physical table and may have an entry in iiphysical_tables as well as iitables.
In most Enterprise Access products, this table is keyed on table_name plus table_owner:
Column Name
Data Type
Description
table_name
char(256)
The table name. This is an object name.
table_owner
char(32)
The table owner's user name.
table_stats
char(1)
Y if this object has entries in the iistats table.
table_indexes
char(1)
Y if this object has entries in the iiindexes table that refer to this as a base table.
is_readonly
char(1)
Y if updates are physically allowed on this object.
concurrent_access
char(1)
Y if concurrent access is allowed.
num_rows
integer
The estimated number of rows in the table. Set to -1 if unknown.
storage_structure
char(16)
The storage structure of the table. Possible values are: heap, btree, isam, or hash.
is_compressed
char(1)
Indicates if the table is stored in compressed format. Y if it is compressed, N if not compressed, or blank if unknown.
key_is_compressed
char(1)
Indicates if the table uses compression. Y if the table uses compression, N if no compression, or blank if unknown.
duplicate_rows
char(1)
Contains U if rows must be unique, D if duplicates are allowed, or blank if unknown.
unique_rule
char(1)
Contains U if the storage structure is unique, D if duplicates are allowed, or blank if unknown or inapplicable.
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 in the object for Ingres. Set to -1 if this is unknown.
allocation_size
integer
The table allocation size, in pages. Set to -1 if unknown.
extend_size
integer
The extend size, in pages. Set to -1 if unknown.
allocated_pages
integer
The total number of pages allocated to the table.
row_security_audit
char(1)
Contains Y if per-row security is enabled, N if not.
table_pagesize
integer
Stores the pages of a table.
table_relversion
smallint
Table layout version. Starts at zero when table is first created and is incremented when column layouts are altered; reset to zero when the table is modified.
table_reltotwid
integer
Width of table record in bytes.
label_granularity
char(1)
An empty string.
This column is deprecated.
security_label
char(8)
An empty string.
This column is deprecated.
Last modified date: 12/14/2023