SQL Reference

OBJCAT.INDEXEXTENSIONS

Contains a row for each index extension.

Table 113. OBJCAT.INDEXEXTENSIONS Catalog View
Column Name Data Type Nullable Description
IESCHEMA VARCHAR(128)
Qualified name of index extension.
IENAME VARCHAR(18)
DEFINER VARCHAR(128)
Authorization ID under which the index extension was defined.
CREATE_TIME TIMESTAMP
Time at which the index extension was defined.
KEYGENFUNCSCHEMA VARCHAR(128)
Qualified name of key generation function.
KEYGENFUNCNAME VARCHAR(18)
KEYGENSPECIFICNAME VARCHAR(18)
Key generation function specific name.
TEXT CLOB(64K)
The full text of the CREATE INDEX EXTENSION statement.
REMARKS VARCHAR(254)
User-supplied comment, or null.


[ Top of Page | Previous Page | Next Page ]