Each row represents an index extension.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
IESCHEMA | VARCHAR (128) | Schema name of the index extension. | |
IENAME | VARCHAR (128) | Unqualified name of the index extension. | |
OWNER | VARCHAR (128) | Authorization ID of the owner of the index extension. | |
OWNERTYPE | CHAR (1) |
|
|
CREATE_TIME | TIMESTAMP | Time at which the index extension was defined. | |
KEYGENFUNCSCHEMA | VARCHAR (128) | Schema name of the key generation function. | |
KEYGENFUNCNAME | VARCHAR (128) | Unqualified name of the key generation function. | |
KEYGENSPECIFICNAME | VARCHAR (128) | Name of the key generation function instance (might be system-generated). | |
TEXT | CLOB (2M) | Full text of the CREATE INDEX EXTENSION statement. | |
DEFINER1 | VARCHAR (128) | Authorization ID of the owner of the index extension. | |
REMARKS | VARCHAR (254) | Y | User-provided comments, or the null value. |
Note:
|