Static Data Dictionary Views, 28 of 452

ALL_IND_COLUMNS

ALL_IND_COLUMNS describes the columns of indexes on all tables accessible to the current user.

Related views:

DBA_IND_COLUMNS describes the columns of indexes on all tables in the database.

USER_IND_COLUMNS describes the columns of indexes owned by the current user and columns of indexes on tables owned by the current user. This view does not display the INDEX_OWNER or TABLE_OWNER columns.

Column Datatype NULL Description

INDEX_OWNER

VARCHAR2(30)

NOT NULL

Owner of the index

INDEX_NAME

VARCHAR2(30)

NOT NULL

Name of the index

TABLE_OWNER

VARCHAR2(30)

NOT NULL

Owner of the table or cluster

TABLE_NAME

VARCHAR2(30)

NOT NULL

Name of the table or cluster

COLUMN_NAME

VARCHAR2(4000)

Column name or attribute of object type column

Note: If you create an index on a user-defined REF column, the system creates the index on the attributes that make up the REF column. Therefore, the column names displayed in this view are the attribute names, with the REF column name as a prefix, in the following form:
"REF_name"."atttribute"

COLUMN_POSITION

NUMBER

NOT NULL

Position of column or attribute within the index

COLUMN_LENGTH

NUMBER

NOT NULL

Indexed length of the column

DESCEND

VARCHAR2(4)

Whether the column is sorted in descending order (Y/N)

Column	Datatype	NULL	Description
`INDEX_OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the index
`INDEX_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the index
`TABLE_OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the table or cluster
`TABLE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the table or cluster
`COLUMN_NAME`	`VARCHAR2(4000)`		Column name or attribute of object type column
			Note: If you create an index on a user-defined REF column, the system creates the index on the attributes that make up the REF column. Therefore, the column names displayed in this view are the attribute names, with the REF column name as a prefix, in the following form: "REF_name"."atttribute"
`COLUMN_POSITION`	`NUMBER`	`NOT NULL`	Position of column or attribute within the index
`COLUMN_LENGTH`	`NUMBER`	`NOT NULL`	Indexed length of the column
`DESCEND`	`VARCHAR2(4)`		Whether the column is sorted in descending order (Y/N)