Icon DROP TEXT FILTER

Drops an existing text filter.

Syntax
DROP TEXT FILTER <Name>

Usage
Use this statement to drop a text filter.

Warning Dropping a text filter that is in use may cause large amounts of text to be included in the text index. For example, if you included a CLOB column containing HTML in a text index that relied on an HTML text filter to remove all formatting prior to indexing, then removing the HTML text filter will cause the formatting to be subsequently included in the text index whenever the CLOB column is updated.

Examples
-- The following statement drops the HTML text filter.

DROP TEXT FILTER "HTML"

Required Privileges
The current user must be granted the system-defined Administrators role in order to execute this statement. Please see the User Security topic for more information.

SQL 2003 Standard Deviations
This statement deviates from the SQL 2003 standard in the following ways:

DeviationDetails
ExtensionThis SQL statement is an ElevateDB extension
Image