A.6 ALL_IND_COLUMNS

ALL_IND_COLUMNS data dictionary for Oracle Database Gateway for DRDA.

The ALL_IND_COLUMNS view contains the columns of indexes on all tables that are accessible to the current user.

Column names Description

INDEX_OWNER

Owner of the index

INDEX_NAME

Name of the index

TABLE_OWNER

Owner of the table or cluster

TABLE_NAME

Name of the table or cluster

COLUMN_NAME

Column name or attribute of object type column

COLUMN_POSITION

Position of a column or attribute within the index

COLUMN_LENGTH

Indexed length of the column

CHAR_LENGTH

Maximum codepoint length of the column

DESCEND

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