Alter Table Rename Index. Table view synonym not just indexes. How to Drop or Remove an Index.
For descriptions of all table options see Section 13120 CREATE TABLE StatementHowever ALTER TABLE ignores DATA DIRECTORY and INDEX. SQL rename drop_me2 to drop_me. Table_options signifies table options of the kind that can be used in the CREATE TABLE statement such as ENGINE AUTO_INCREMENT AVG_ROW_LENGTH MAX_ROWS ROW_FORMAT or TABLESPACE.
New_index_name is the new index name which cannot duplicate the name of an index in the resulting table after changes have been applied.
ALTER INDEX RENAME TO. For descriptions of all table options see Section 13120 CREATE TABLE StatementHowever ALTER TABLE ignores DATA DIRECTORY and INDEX. 1 - Check how many indexes your table has and what they are. Table-alteration clauses Use this clause to alter the.
