Column Name | Data Type | Description |
table_name | char(256) | Name of the object column is part of |
table_owner | char(32) | The owner of the object |
create_date | char(25) | Date object was created |
table_type | char(8) | T if attribute is part of a table V if attribute is part of a view I if attribute is part of an index |
table_subtype | char(1) | Always N |
table_version | char(5) | II9.0 for current release of product |
system_use | char(1) | S if part of a system catalog U if part of a user object |
column_name | char(256) | Name of attribute. |
column_datatype | char(32) | Long name of data type for this column |
column_length | integer | Size in bytes of data |
column_nulls | char(1) | N if not nullable Y if column supports nulls |
column_defaults | char(1) | N if no default for this column Y if a default value exists for this column |
column_sequence | smallint | Position of this column in table |
key_sequence | smallint | Position in key for this table or zero |