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.
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 |
---|---|---|---|
|
|
|
Owner of the index |
|
|
|
Name of the index |
|
|
|
Owner of the table or cluster |
|
|
|
Name of the table or cluster |
|
|
Column name or attribute of the object type column |
|
Note: If you create an index on a user-defined
|
|||
|
|
|
Position of the column or attribute within the index |
|
|
|
Indexed length of the column |
|
|
Maximum codepoint length of the column |
|
|
|
Indicates whether the column is sorted in descending order ( |
See Also: