The DBA_IND_COLUMNS view provides the information about all columns included in indexes on all tables in the database.
Parameter | Type | Description |
---|---|---|
index_owner | TEXT | The username of the owner to which an 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 or property name of the object column. |
column_position | SMALLINT | The position of the column in the index. |
column_length | SMALLINT | The length of the column. Unit: bytes. |
char_length | NUMERIC | The length of the column. Unit: characters. |
descend | CHARACTER(1) | This parameter is supported for compatibility only. The value is Y in descending order. |