Reference Guide > TDV and Business Directory System Tables > ALL_INDEXES
 
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.