ALL_TAB_COLUMNS is a view that provides column metadata for all user-defined tables and views accessible to the current user.
Columns
| Column | Type | Description |
|---|---|---|
owner | CHARACTER VARYING | The username of the owner of the table or view where the column is located |
schema_name | CHARACTER VARYING | The name of the schema to which the table or view belongs |
table_name | CHARACTER VARYING | The name of the table or view |
column_name | CHARACTER VARYING | The name of the column |
data_type | CHARACTER VARYING | The data type of the column |
data_length | NUMERIC | The length of the text columns |
data_precision | NUMERIC | The precision of the NUMBER column, measured in digits |
data_scale | NUMERIC | The number of digits to the right of the decimal point in a NUMBER column |
nullable | CHARACTER(1) | Whether the column allows null values: Y (nullable) or N (not nullable) |
column_id | NUMERIC | The relative position of the column within the table or view |
data_default | CHARACTER VARYING | The default value assigned to the column |