The ALL_IND_COLUMNS view provides the information about columns included in indexes on the tables accessible by the current user.
| Parameter | Type | Description |
|---|---|---|
| index_owner | TEXT | The username of the owner to which the index belongs. |
| schema_name | TEXT | The name of the schema to which the index belongs. |
| index_name | TEXT | The name of the index. |
| table_owner | TEXT | The username of the owner to which the table belongs. |
| 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 a column in characters. |
| descend | CHARACTER(1) | This parameter is supported for compatibility only. The value is Y in descending order. |