ALL_INDEXES

The ALL_INDEXES system table exposes all the indexes on all published tables in published data sources to which the current user has access. Users can see indexes on tables for which they have at least one privilege.

Column

TDV JDBC Data Type

Nullable

Description

INDEX_ID

INTEGER

 

Identifier of the index. Primary key.

INDEX_NAME

VARCHAR(255)

 

Name of the index.

INDEX_TYPE

VARCHAR(11)

 

Type of the index, whether primary key or other.

COLUMN_NAME

VARCHAR(255)

 

Name of the indexed column.

ORDINAL_POSITION

SMALLINT

 

Position of the indexed column in relation to other columns in the same index.

SORT_ORDER

CHAR(1)

 

Sort order: A for ascending or D for descending.

TABLE_ID

INTEGER

 

Identifier of the table.

TABLE_NAME

VARCHAR(255)

 

Name of the table.

SCHEMA_ID

INTEGER

Yes

Identifier of the schema.

SCHEMA_NAME

VARCHAR(255)

Yes

Name of the schema.

CATALOG_ID

INTEGER

Yes

Identifier of the catalog.

CATALOG_NAME

VARCHAR(255)

Yes

Name of the catalog.

DATASOURCE_ID

INTEGER

 

Identifier of the data source.

DATASOURCE_NAME

VARCHAR(255)

 

Name of the data source.

BD_DATASOURCE_
NAME

VARCHAR(255)

 

BD name of the data source.

IS_UNIQUE

SMALLINT

 

Indicates whether the index returns unique values.

IS_PRIMARY_KEY

SMALLINT

 

Indicates whether the index is a primary index.

OWNER_ID

INTEGER

 

Identifier for the owner/creator of the index.

OWNER

VARCHAR(255)

 

User name of the owner/creator of the index.

PARENT_PATH

VARCHAR(1043)

 

Path to the parent container.

BD_PARENT_PATH

VARCHAR(255)

 

BD path to the parent container.