USER_IND_COLUMNS v11
The USER_IND_COLUMNS view provides information about all columns referred to in indexes on tables that are owned by the current user.
| Name | Type | Description |
|---|---|---|
schema_name | TEXT | Name of the schema in which the index belongs. |
index_name | TEXT | The name of the index. |
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. |