Purpose
The ALL_IND_COLUMNS view displays the columns of indexes on all tables accessible to the current user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
USER_IND_COLUMNS
DBA_IND_COLUMNS
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| INDEX_OWNER | VARCHAR2(128) | NO | The owner of the index. |
| INDEX_NAME | VARCHAR2(128) | NO | The name of the index. |
| TABLE_OWNER | VARCHAR2(128) | NO | The owner of the table containing the index. |
| TABLE_NAME | VARCHAR2(128) | NO | The name of the table containing the index. |
| COLUMN_NAME | VARCHAR2(4000) | NO | The name of the indexed column. |
| COLUMN_POSITION | NUMBER | NO | The position of the indexed column in the index. |
| COLUMN_LENGTH | NUMBER | NO | The length of the indexed column. |
| CHAR_LENGTH | NUMBER | NO | The character length of the indexed column. |
| DESCEND | VARCHAR2(4) | NO | Indicates whether the column is sorted in descending order or ascending order. |