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