A. System Catalogs : Standard Catalog Interface : Standard Catalogs for All Databases : iiphysical_tables Catalog
 
Share this page                  
iiphysical_tables Catalog
Caution! The iiphysical_tables catalog will not exist in the next major release. Applications should query iitables for physical table information.
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. You can query the physical_source column, in iidbcapabilities, to determine whether you must query iiphysical_tables. If you do not want to query iidbcapabilities, you must always query iiphysical_tables to be sure of getting the correct information.
If a queriable object is type T or I (index Ingres installation only), it is a physical table and can 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 name of the table
table_owner
char(32)
The owner of the table
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 iiindexes that see 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
-1 if unknown
storage_structure
char(16)
The storage structure of the table:
HEAP
BTREE
ISAM
HASH
is_compressed
char(1)
Y if the table is compressed
N if not compressed
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)
U if rows must be unique
D if duplicates are allowed
Blank if unknown
unique_rule
char(1)
U if the storage structure is unique
D if duplicates are allowed
Blank if unknown or inapplicable
number_pages
integer
The estimated number of physical pages
-1 if unknown
overflow_pages
integer
The estimated number of overflow pages
-1 if unknown
row_width
integer
The size in bytes of the uncompressed binary value for the row
-1 if unknown
allocation_size
integer
The allocation size, in pages
-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 per-row security auditing is enabled
N if not
table_pagesize
integer
The page size 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.