USER_TAB_COLUMNS v17
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 in the table. |
data_default | CHARACTER VARYING | Default value assigned to the column. |