Dropping an index A Lucene index can be dropped by the table owner. luceneSupport optional tooldropping an index

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 for details.

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