# Listing indexes

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 )
    )

## Example

        -- list all the indexes
        SELECT * FROM TABLE( LUCENESUPPORT.LISTINDEXES() ) T;

Parent topic: Using the luceneSupport optional tool
Related reference
Creating an index
Updating an index
Querying an index
Dropping an index
Running the luceneSupport tool with a security manager