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