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. |