Column Name | Data Type | Description |
table_name | char(256) | The name of the table. Must be a valid name. |
table_owner | char(32) | The owner of the table. Must be a valid username. |
column_name | char(256) | The column’s name. Must be a valid name. |
column_datatype | char(32) | The column’s data type name returned to users and applications: integer smallint int float real double precision char character varchar c text date money decimal user data types (UDTs) For details on UDTs, see the Object Management Extension User Guide. |
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 which are specified without length (money and date). This length is not the actual length of the column’s internal storage. |
column_scale | smallint | The second number in a two-part user length specification; for typename (len1, len2) it will be len2. |
column_nulls | char(8) | Y if the column can contain null values, N if not. |
column_defaults | char(8) | Y if the column is given a default value when a row is inserted. N if not. |
column_sequence | smallint | The number of this column in the corresponding table’s create statement, numbered from 1. |
key_sequence | smallint | The order of this column in the primary key, numbered from 1. For a 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. This is unique if the unique_rule column for the table’s corresponding entry in iitables is set to U. |
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 a value that indicates the data type of the column. 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: integer -30/30 float -31/31 c -32/32 text -37/37 date -3/3 money -5/5 char -20/20 varchar -21/21 decimal -10/10 |