ALL_IND_COLUMNS v11

Edit this page

The ALL_IND_COLUMNS view provides information about columns included in indexes on the tables accessible by the current user.

NameTypeDescription
index_ownerTEXTUser name of the index’s owner.
schema_nameTEXTName of the schema in which the index belongs.
index_nameTEXTThe name of the index.
table_ownerTEXTUser name of the table owner.
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.