You can use a table function to list all Lucene indexes.
After the luceneSupport tool has been loaded, anyone can list the Lucene indexes by selecting from the following table function:
LUCENESUPPORT.LISTINDEXES()
RETURNS TABLE
(
SCHEMANAME VARCHAR( 128 ),
TABLENAME VARCHAR( 128 ),
COLUMNNAME VARCHAR( 128 ),
LASTUPDATED TIMESTAMP,
LUCENEVERSION VARCHAR( 20 ),
ANALYZER VARCHAR( 32672 ),
INDEXDESCRIPTORMAKER VARCHAR( 32672 )
)
-- list all the indexes
SELECT * FROM TABLE( LUCENESUPPORT.LISTINDEXES() ) T;