Postgres Plus Advanced Server Oracle Compatibility Developer's Guide
10.22 DBA_IND_COLUMNS
The DBA_IND_COLUMNS view provides information about all columns included in indexes, on all tables in the database.
Name |
Type |
Description |
index_owner |
TEXT |
User name of the index’s owner. |
schema_name |
TEXT |
Name of the schema in which the index belongs. |
index_name |
TEXT |
Name of the index. |
table_owner |
TEXT |
User name of the table’s owner. |
table_name |
TEXT |
Name of the table in which the index belongs. |
column_name |
TEXT |
Name of column or attribute of object column. |
column_position |
SMALLINT |
The position of the column in the index. |
column_length |
SMALLINT |
The length of the column (in bytes). |
char_length |
NUMERIC |
The length of the column (in characters). |
descend |
CHAR(1) |
Sorted order of the column on disk. Always set to Y (descending); included for compatibility only. |







