DB_IND_COLUMNS

DESC: descending order.
ASC: ascending order.

DB_IND_COLUMNS displays all index columns accessible to the current user. This view exists in the PG_CATALOG and SYS schemas.

**Table 1** DB_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 a column in an index.
column_length	numeric	Column length.
char_length	numeric	Length of a column (character type).
descend	character varying(4)	Sorting mode of a column. The options are as follows: DESC: descending order. ASC: ascending order.
collated_column_id	numeric	Internal serial number of the language sorting columns.