SYSIQTABCOL System View

Presents group information from ISYSIQTABCOL in a readable format. Each row in the SYSIQTABCOL view describes a column in an IQ table.

ALTER VIEW "SYS"."SYSIQTABCOL"
as select * from SYS.ISYSIQTABCOL

Note: This view replaces the deprecated system view SYSIQCOLUMN.

Column name	Column type	Description
table_id	unsigned int	The table number uniquely identifies the table to which this column belongs. It corresponds to the table_id column of SYSTAB.
column_id	unsigned int	Each table starts numbering columns at 1. The order of column numbers determines the order that columns are displayed in the command select * from table.
link_table_id	unsigned int	For internal use.
link_column_id	unsigned int	For internal use.
max_length	unsigned int	Indicates the maximum length allowed by the column.
approx_unique_count	rowid	Approximate number of unique values (cardinality) of this column.
cardinality	rowid	The actual number of unique values (cardinality) of this column.
has_data	char(1)	Indicates that the column contains data (T/F).
has_original	char(1)	Indicates the join index has the original data (T/F).
original_not_null	char(1)	Indicates the join index column with the original data was NOT NULL (T/F).
original_unique	char(1)	Indicates the join index column with the original data was UNIQUE (T/F).

Constraints on underlying system table:

Primary key (table_id)