Previous PageTable Of ContentsNext Page

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.

Previous PageTable Of ContentsNext Page