DB_IND_COLUMNS

DB_IND_COLUMNS displays all index columns accessible to the current user. This view exists in both 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 the column in the index
column_length	numeric	Column length
char_length	numeric	Length of a column (character type).
descend	character varying	Indicates the sorting mode of a column. The value can be DESC or ASC.
collated_column_id	numeric	Provides the internal serial number of the language sorting columns.

Parent topic: System Views

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.