USER_IND_COLUMNS v10

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

NameTypeDescription
schema_nameTEXTName of the schema in which the index belongs.
index_nameTEXTThe name of the index.
table_nameTEXTThe name of the table to which the index belongs.
column_nameTEXTThe name of the column.
column_positionSMALLINTThe position of the column within the index.
column_lengthSMALLINTThe length of the column (in bytes).
char_lengthNUMERICThe length of the column (in characters).
descendCHARACTER(1)Always set to Y (descending); included for compatibility only.