602SQL Documentation Index  
<­ALTER FULLTEXT Statement UpFulltext in 602SQL A Size Restriction of Indexed Files­>

DROP FULLTEXT Statement

statement_DROP_FULLTEXT ::= DROP FULLTEXT [ scheme. ] identifier

The DROP FULLTEXT statement deletes a fulltext system specified by the identifier in the selected schema. The word table, reference table and sequence for document numbering are deleted as well (for internal fulltext systems). The binary file with indexes are deleted for external fulltext systems. The document table and documents are not affected.

Example

Delete a fulltext system from an application.

DROP FULLTEXT FT_FORUM

See

<­ALTER FULLTEXT Statement UpFulltext in 602SQL A Size Restriction of Indexed Files­>