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_ |
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. |