A. System Catalogs : Standard Catalog Interface : Standard Catalogs for All Databases : iicolumns Catalog
 
Share this page                  
iicolumns Catalog
For each queriable object in the iitables catalog, there are one or more entries in the iicolumns catalog. Each row in iicolumns contains the information on a column of the object. Iicolumns is used by Ingres tools and user programs 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 name of the column
column_datatype
char(32)
The data type of the column
column_length
integer
The length of the column. Displays the precision for decimal data, zero for money and date
column_scale
integer
Displays the scale for decimal data type, zero for all other data types
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(1)
Y if the column can contain null values, N if the column cannot contain null values
column_defaults
char(1)
Y if the column has a default value when a row is inserted, N if not
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, numbered from 1, of this column in the primary key for a table. 0 if this column is not part of the primary key
sort_direction
char(1)
A for ascending; used when key_sequence is greater than 0
column_ingdatatype
integer
Contains the internal numeric representation of the column's external data type.
If the value is positive, the column is not nullable.
If the value is negative, the column is nullable.
If the installation has user-defined data types (UDTs), this column contains the data type that the UDT is converted to when returned.
The data types and their corresponding values are:
 
 
INTEGER
30/-30
 
 
FLOAT
31/-31
 
 
C
32/-32
 
 
TEXT
37/-37
 
 
INGRESDATE*
3/-3
 
 
DECIMAL
10/-10
 
 
MONEY
5/-5
 
 
CHAR
20/-20
 
 
VARCHAR
21/-21
 
 
LONG VARCHAR
22/-22
 
 
BYTE
23/-23
 
 
LONG BYTE
25/-25
 
 
TABLE_KEY
12/-12
 
 
OBJECT_KEY
11/-11
 
 
ANSIDATE
4/-4
 
 
TIME WITHOUT TIMEZONE
6/-6
 
 
TIME WITH TIMEZONE
7/-7
 
 
TIME
8/-8
 
 
TIMESTAMP WITHOUT TIMEZONE
9/-9
 
 
TIMESTAMP WITH TIMEZONE
18/-18
 
 
TIMESTAMP
19/-19
 
 
INTERVAL YEAR TO MONTH
33/-33
 
 
INTERVAL DAY TO SECOND
34/-34
 
 
BOOLEAN
38/-38
 
 
*Returned to applications as a string.
column_internal_
datatype
char(32)
The internal data type of the datatype column.
If the installation has user-defined data types, this column contains the user-specified name.
column_internal_
length
integer
The internal length of the column.
0 if the data type is date or money
Does not include the null indicator byte for nullable columns or the 2-byte length specifier for varchar and text columns
column_internal_
ingtype
smallint
The numeric representation of the internal data type.
See column_ingdatatype for a list of valid values.
If the installation has user-defined data types, this column contains the user-specified data type number.
column_system_
maintained
char(1)
Y if system-maintained
N if not system-maintained
column_updateable
char(1)
Y if the column can be updated
N if the column cannot be updated
Blank if unknown
column_has_default
char(1)
Y if the column is defined with a default value,
N if the column is defined as not default,
U if the column is defined without a default
Blank if unknown
column_default_val
varchar(1501)
The value of the default if the column has one
Null if the default is not specified, NOT DEFAULT, or not known
It contains surrounding and embedded quotes for character defaults, per ISO Entry SQL92 semantics.
security_audit_key
char(1)
Y if column is a security audit key
N if column is not a security audit key
column_always_ident
char(1)
Y if column is declared as GENERATED ALWAYS AS IDENTITY, N if not
column_bydefault_ident
char(1)
Y if column is declared as GENERATED BY DEFAULT AS IDENTITY, N if not
column_encrypted
char(1)
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(1)
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(1)
Y if a data validation hash is included for encryption; for Ingres 10.0 this is always Y for encrypted columns.