USER_TAB_COLUMNS v11
The USER_TAB_COLUMNS view displays information about all columns in tables and views owned by the current user.
| Name | Type | Description |
|---|---|---|
schema_name | CHARACTER VARYING | Name of the schema in which the table or view resides. |
table_name | CHARACTER VARYING | Name of the table or view in which the column resides. |
column_name | CHARACTER VARYING | Name of the column. |
data_type | CHARACTER VARYING | Data type of the column. |
data_length | NUMERIC | Length of text columns. |
data_precision | NUMERIC | Precision (number of digits) for NUMBER columns. |
data_scale | NUMERIC | Scale of NUMBER columns. |
nullable | CHARACTER(1) | Whether or not the column is nullable – possible values are: Y – column is nullable; N – column does not allow null. |
column_id | NUMERIC | Relative position of the column within the table. |
data_default | CHARACTER VARYING | Default value assigned to the column. |