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.