ALL_IND_COLUMNS describes the columns of indexes on all tables accessible to the current user.
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.
Note:
For join indexes, theTABLE_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:
|
|||
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) |