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