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 the MySQL mode.
Related views
USER_IND_COLUMNSDBA_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. |