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