The USER_IND_COLUMNS view provides the information about all columns included in indexes on the tables that are owned by the current user.

Parameter Type Description
schema_name TEXT The name of the schema to which an 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 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.