ALTER INDEX

ALTER INDEX changes the parameters of an index.

Syntax

Field	Use
name	The identifier of the index you want to alter.

Details

Tables

Note that when enabling indexes on tables, the first index you enable must be the table’s primary index, which was created at the same time as the table itself. Only after enabling the primary index can you enable any secondary indexes.

Privileges

The privileges required to execute this statement are:

• Ownership of the index.

See also

• SHOW INDEXES
• SHOW CREATE VIEW
• SHOW VIEWS
• SHOW SOURCES
• SHOW SINKS