Displaying a List of TEXT Indexes Using Interactive SQL

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

Connect to the database as a user with DBA or RESOURCE authority.
Execute a SELECT statement.

To list all Sybase IQ TEXT indexes:

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

To list all TEXT indexes, including those on catalog tables:

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;