Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-14
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

ALL_IND_COLUMNS

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

Related Views

Note:

For join indexes, the TABLE_NAME and TABLE_OWNER columns in this view may not match the TABLE_NAME and TABLE_OWNER columns you find in the *_INDEXES (and other similar) data dictionary views.
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 the 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"."attribute"

COLUMN_POSITION NUMBER NOT NULL Position of the column or attribute within the index
COLUMN_LENGTH NUMBER NOT NULL Indexed length of the column
CHAR_LENGTH NUMBER   Maximum codepoint length of the column
DESCEND VARCHAR2(4)   Indicates whether the column is sorted in descending order (DESC) or ascending order (ASC)