DBA_IND_COLUMNS v11
The DBA_IND_COLUMNS view provides information about all columns included in indexes, on all tables in the database.
| 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 | Name of the index. |
table_owner | TEXT | User name of the table’s owner. |
table_name | TEXT | Name of the table in which the index belongs. |
column_name | TEXT | Name of column or attribute of object column. |
column_position | SMALLINT | The position of the column in 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. |