Purpose
The USER_IND_COLUMNS view displays the indexed columns of all tables owned by the user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
ALL_IND_COLUMNS
DBA_IND_COLUMNS
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| INDEX_NAME | VARCHAR2(128) | NO | The name of the index. |
| TABLE_OWNER | VARCHAR2(128) | NO | The owner 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. |