ALTER INDEX

Use the ALTER INDEX statement to change the clustering attribute or the locking mode of an existing index.

This statement is an extension to the ANSI/ISO standard for SQL.

Syntax

                          (1)
>>-ALTER INDEX--index--+--------TO--+-----+--CLUSTER--+--------><
                       |            '-NOT-'           |
                       |  (2)                         |
                       '--------LOCK MODE--+-NORMAL-+-'
                                           '-COARSE-'

Notes:

Dynamic Server only
Extended Parallel Server only

Element	Description	Restrictions	Syntax
index	Name of the index to be altered	Must exist	Database Object Name

Usage

ALTER INDEX is valid only for indexes that the CREATE INDEX statement created explicitly. ALTER INDEX cannot modify an index on a temporary table, nor an index that the database server created implicitly to support a constraint.

You cannot change the collating order of an existing index. If you use ALTER INDEX to modify an index after the SET COLLATION statement of Dynamic Server has specified a non-default collating order, the SET COLLATION statement has no effect on the index.