 |  LoginProducts  SalesSupportDownloadsAbout |
| Home » Technical Support » ElevateDB Technical Support » Product Manuals » ElevateDB Version 2 SQL Manual » DDL Statements » DROP TEXT FILTER |
DROP TEXT FILTERDrops an existing text filter.
Syntax
Usage
Use this statement to drop a text filter.
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
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:
Syntax
DROP TEXT FILTER <Name>
Usage
Use this statement to drop a text filter.
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:
| Deviation | Details |
| Extension | This SQL statement is an ElevateDB extension |
More Support Options
This web page was last updated on Friday, January 31, 2025 at 08:42 AM | Privacy PolicySite Map © 2025 Elevate Software, Inc. All Rights Reserved Questions or comments ?  E-mail us at info@elevatesoft.com |
