Was this helpful?
iiphysical_tables Catalog
The information in the iiphysical_tables catalog overlaps with some of the information in iitables. You can query the physical_source column in iidbcapabilities to determine whether you must query iiphysical_tables. If you do not want to make this check, then you must always query iiphysical_tables to be sure of getting the correct information.
If a queryable object is type T (table), then it is a physical table and may have an entry in iiphysical_tables as well as iitables.
Column Name
Data Type
Description
table_name
char(256)
The table name. This is an name.
table_owner
char(32)
The table owner’s username.
table_stats
char(8)
Y if this object has entries in the iistats table, N if it does not. If blank, it is undetermined if the object has entries in iistats and you should check iistats directly.
table_indexes
char(8)
Y if this object has entries in the iiindexes table that refer to this as a base table, N if not. If blank, it is undetermined if the object has entries in the iiindexes table that refer to it as a base table, and you should check iiindexes directly. This field is only used for optimization for Ingres databases, as other Enterprise Access products cannot automatically supply this information.
is_readonly
char(8)
Y if updates are physically allowed on this object, N if not. The field is blank if this is unknown. This is used for tables that are defined to the Enterprise Access for retrieval. If this field is set to Y, updates will not be allowed regardless of what permissions might be set for the table.
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, B-tree, isam, or hash. Set to blank if the structure is unknown.
is_compressed
char(8)
Indicates if the table is stored in compressed format. Y if it is compressed, N if not compressed, blank if unknown.
duplicate_rows
char(8)
Indicates if duplicate rows are allowed in the table. Set to U if rows must be unique, D if duplicates are allowed, or blank if unknown.
unique_rule
char(8)
Indicates if the storage structure key is unique. Set to 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 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.
Last modified date: 04/03/2024