# Dropping an index

A Lucene index can be dropped by the table owner.

If SQL authorization is enabled, the database owner is the only account which can drop an index on another user's table. The following procedure makes this possible:

    LUCENESUPPORT.DROPINDEX
    (
        SCHEMANAME VARCHAR( 128 ),
        TABLENAME VARCHAR( 128 ),
        TEXTCOLUMN VARCHAR( 128 )
    )

The arguments are the same as those for `CREATEINDEX`. See Creating an index for details.

## Example

    -- drop an index
    CALL LUCENESUPPORT.DROPINDEX
    (
        'ruth', 'poemView', 'poemText'
    );

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