ALL_IND_COLUMNS v11
The ALL_IND_COLUMNS view provides information about columns included in indexes on the tables accessible by the current user.
| Name | Type | Description |
|---|---|---|
index_owner | TEXT | User name of the index’s owner. |
schema_name | TEXT | Name of the schema in which the index belongs. |
index_name | TEXT | The name of the index. |
table_owner | TEXT | User name of the table owner. |
table_name | TEXT | The name of the table to which the index belongs. |
column_name | TEXT | The name of the column. |
column_position | SMALLINT | The position of the column within the index. |
column_length | SMALLINT | The length of the column (in bytes). |
char_length | NUMERIC | The length of the column (in characters). |
descend | CHARACTER(1) | Always set to Y (descending); included for compatibility only. |