 |  LoginProducts  SalesSupportDownloadsAbout |
| Home » Technical Support » ElevateDB Technical Support » Product Manuals » ElevateDB Version 2 SQL Manual » DDL Statements » DROP WORD GENERATOR |
DROP WORD GENERATORDrops an existing word generator.
Syntax
Usage
Use this statement to drop a word generator.
Dropping a word generator that is in use may cause text to be included in a text index that is not desired. For example, if you included a CLOB column containing German text in a text index that relied on a German word generator to properly parse all words prior to indexing, then removing the German word generator will cause different words 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 WORD GENERATOR <Name>
Usage
Use this statement to drop a word generator.
Dropping a word generator that is in use may cause text to be included in a text index that is not desired. For example, if you included a CLOB column containing German text in a text index that relied on a German word generator to properly parse all words prior to indexing, then removing the German word generator will cause different words to be subsequently included in the text index whenever the CLOB column is updated.Examples
-- The following statement drops the Pascal word generator. DROP WORD GENERATOR "Pascal"
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 |
