11. OpenSQL Standard Catalogs : Standard Catalog Interface : The iicolumns Catalog
 
Share this page                  
The iicolumns Catalog
For each queryable object in the iitables catalog, there are one or more entries in the iicolumns catalog. Each row in iicolumns contains the logical information on a column of the object. User interfaces and user programs use the iicolumns catalog to perform dictionary operations and dynamic queries.
Column Name
Data Type
Description
table_name
char(256)
The name of the table.
table_owner
char(32)
The owner of the table.
column_name
char(256)
The column name.
column_datatype
char(32)
The column data type name returned to users and applications:
Decimal
Integer
Int
Float
Real
Double precision
Char
Character
Varchar
Date
column_length
integer
The length of the column returned to users and applications. If a data type contains two length specifiers, this column uses the first length. Set to zero for the data types that are specified without length (date). This length is not the actual length of the column's internal storage. For decimal columns, contains the precision.
column_scale
integer
The second number in a two-part user length specification. For typename (len1, len2) it will be len2.
column_collid
smallint
The column's collation ID. Valid values are:
-1 the default
1 for unicode
2 for unicode_case_insensitive
3 for sql_character
column_nulls
char(8)
Contains Y if the column can contain null values, N if the column cannot contain null values.
column_defaults
char(8)
Contains Y if the column is given a default value when a row is inserted, or N if the column is not given a default value.
column_sequence
integer
The position of the column based on the DDL for the object, starting at 1. For example, the first column in a CREATE statement displays 1 in this column.
key_sequence
integer
The order of this column in the primary key, numbered from 1. For an Ingres table, this indicates the column's order in the primary storage structure key. If 0, then this column is not part of the primary key.
sort_direction
char(8)
Defaults to A (for ascending) when key_sequence is greater than 0; otherwise, this value is a blank.
column_ingdatatype
smallint
Contains the numeric Ingres representation of the column's external data type (the data type returned to users and applications).
If the installation has user-defined data types (UDTs), this column contains the data type that the UDT is converted to when returned to an Ingres user interface product.
If the value is positive then the column is not nullable. If the value is negative, then the column is nullable. The data types and their corresponding values are:
decimal - 10/10
integer - 30/30
float - 31/31
date* - 3/3
char - 20/20
varchar - 21/21
* Returned as a string
column_internal_
datatype
char(32)
The internal data type of the column: char, c, varchar, text, integer, float, date, money, table_key, object_key. If the installation has user-defined data types, this column contains the user-specified name.
column_internal_
length
smallint
The internal length of the column. For example, for data type smallint, this column contains 2. Contains 0 if the data type is fixed-length. The length does not include the null indicator byte for nullable columns, or the length specifier byte for varchar and text columns.
column_internal_
ingtype
smallint
Contains the numeric representation of the internal datatype. For a list of valid values, see column_ingdatatype. If the installation has user-defined data types, this column contains the user-specified data type number.
column_system_
maintained
char(8)
Contains Y if the column is system-maintained, or N if not system-maintained.
column_updatable
char(8)
Contains Y if the column can be updated, N if not, or blank if unknown.
column_has_default
char(8)
Contains Y if the column has a default value, N if not, or blank if unknown.
column_default_
value
varchar(1501)
The default value defined for the column.
security_audit_key
char(1)
Contains Y if the column is a security audit key, N if not.
column_always_indent
char
Contains Y if the column is declared as "generated always as identity," N if not.
column_bydefault_ indent
char
Contains Y if the column is declared as "generated by default as identity," N if not.
column_encrypted
char
Contains Y if the column is encrypted, N if not.
column_encrypt_width
integer
The width of an encrypted column, including the data itself and encryption overhead.
column_encrypt_salt
char
Contains Y if salt (extra initialization bits) is included in the encryption, N if not. The default is Y for encrypted columns.
column_encrypt_crc
char
Contains Y if a data validation hash is included for encryption; for Ingres 10.0, this is always Y for encrypted columns.