Icon ALTER TEXT INDEX

Alters an existing text index on a given table.

Syntax
ALTER TEXT INDEX <Name> ON <TableName>
(<ColumnName> [COLLATE <CollationName>])
[DESCRIPTION <Description>]
[INDEXED WORD LENGTH <WordLength>]
[FILTER TYPE COLUMN <ColumnName>]
[WORD GENERATOR <WordGeneratorName>]
[NO BACKUP FILES]

Usage
Use this statement to alter an existing text index on a table column. Please see the Text Indexing topic for more information.

The NO BACKUP FILES clause is optional. Unless this clause is specified, ElevateDB will create backup files (*.old) of any physical table files that were altered during the execution of the statement. Also, this clause does not apply to physical backup files created for the database catalog, which are always created and retained.

Information All clauses after the column definitions are optional. If they are not specified, then they will not be altered and will stay the same as before the ALTER INDEX statement was executed.

Examples
-- The following statement changes the Notes text
-- index so that the indexed word length is 30 characters

ALTER TEXT INDEX "Notes" ON "Customer"
(Notes COLLATE ANSI_CI)
INDEXED WORD LENGTH 30

Required Privileges
The current user must be granted the ALTER privilege on the specified table 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