A UNIQUE INDEX is created automatically when you create one of the following

• UNIQUE KEY
• PRIMARY KEY

constraint.

It is not possible to modify the index, if you want to change an index, you must drop and then re-create it.