ALL_TAB_COLS provides the same information as the ALL_TAB_COLUMNS view, listing the columns of all tables and views accessible to the current account.
Note
ALL_TAB_COLS is available on PolarDB clusters running version 1.1.7 or later. For clusters running version 1.1.7 or earlier, use ALL_TAB_COLUMNS. To check your cluster version, see Release notes.
Related views
| View | Description |
|---|---|
ALL_TAB_COLS | Lists tables and views accessible to the current account |
ALL_TAB_COLUMNS | Provides the same information as ALL_TAB_COLS. For more information, see ALL_TAB_COLUMNS. |
Columns
| Column | Type | Description |
|---|---|---|
owner | CHARACTER VARYING | The username of the owner of the table or view. |
schema_name | CHARACTER VARYING | The name of the schema that contains the table or view. |
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 maximum length of the column data, in characters. |
data_precision | NUMERIC | The precision of NUMBER columns. The precision is measured by the number of 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 means the column accepts nulls. N means the column does not accept nulls. |
column_id | NUMERIC | The ordinal position of the column within the table or view. |
data_default | CHARACTER VARYING | The default value for the column. |
default_length | INTEGER | The length of the default value for the column. |
data_type_owner | TEXT | The owner of the column's data type. |
char_length | NUMERIC | The column length in characters. Applies only to data of the character type. |
data_semantics | TEXT | The data modifier for the column. |