Displaying a List of TEXT Indexes Using Interactive SQL

View a list of all the TEXT indexes in the database.

1. Connect to the database as a user with any of the following system privileges:
   • CREATE ANY INDEX
   • ALTER ANY INDEX
   • DROP ANY INDEX
   • CREATE ANY OBJECT
   • ALTER ANY OBJECT
   • DROP ANY OBJECT
   • MANAGE ANY DBSPACE
2. Execute a SELECT statement.

SELECT * FROM sp_iqindex() WHERE index_type = 'TEXT';

SELECT index_name, table_name, name FROM SYSIDX, SYSTEXTIDX, SYSTABLE, SYSUSERS 
WHERE SYSIDX.object_id=SYSTEXTIDX.index_id
AND SYSIDX.table_id=SYSTABLE.table_id 
AND SYSTABLE.creator=SYSUSERS.uid;