MY_IND_COLUMNS

MY_IND_COLUMNS displays column information about all indexes accessible to the current user. It is accessible to all users. This view exists in both PG_CATALOG and SYS schema.

**Table 1** MY_IND_COLUMNS columns
Name	Type	Description
index_owner	character varying(64)	Index owner.
index_name	character varying(64)	Index name.
table_owner	character varying(64)	Table owner.
table_name	character varying(64)	Table name.
column_name	name	Column name.
column_position	smallint	Position of the column in the index.
column_length	numeric	Length of the column. For the variable-length type, its value is NULL.
char_length	numeric	Maximum length of a column, in bytes.
descend	character varying	Specifies whether columns are sorted in descending (DESC) or ascending (ASC) order.
collated_column_id	numeric	Not supported. Its value is NULL.