This system table contains information on all table and view columns. Only users with the SELECT ANY DICTIONARY system privilege have access to the table.
Column Name | Description |
---|---|
COLUMN_SCHEMA | Associated schema |
COLUMN_TABLE | Associated table |
COLUMN_OBJECT_TYPE | Associated object type |
COLUMN_NAME | Name of column |
COLUMN_TYPE | Data type of column |
COLUMN_TYPE_ID | ID of data type |
COLUMN_MAXSIZE | Maximum number of characters for strings |
COLUMN_NUM_PREC | Precision for numeric values |
COLUMN_NUM_SCALE | Scale for numeric values |
COLUMN_ORDINAL_POSITION | Position of the column in the table beginning at 1 |
COLUMN_IS_VIRTUAL | States whether the column is part of a virtual table |
COLUMN_IS_NULLABLE | States whether NULL values are allowed (TRUE or FALSE). In case of views this value is always NULL. |
COLUMN_IS_DISTRIBUTION_KEY | States whether the column is part of the distribution key (TRUE or FALSE) |
COLUMN_IS_ZONEMAPPED | States whether the column is zone mapped (TRUE or FALSE) |
COLUMN_PARTITION_KEY_ORDINAL_POSITION | Position of the column in table's composite partition key beginning at 1 or NULL for columns which are not part of it |
COLUMN_DEFAULT | Default value of the column |
COLUMN_IDENTITY | Current value of the identity number generator, if this column has the identity attribute. |
COLUMN_OWNER | Owner of the associated object |
COLUMN_OBJECT_ID | ID of the column |
STATUS | Status of the object |
COLUMN_COMMENT | Comment on the column |