DBA_IND_COLUMNS v17
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 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 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 | Position of the column in the index. |
column_length | SMALLINT | Length of the column in bytes. |
char_length | NUMERIC | Length of the column in characters. |
descend | CHARACTER(1) | Included only for compatibility. Always set to Y (descending). |