how to remove unique constraint in mysql by query code example

Example: remove unique key from a table

example: alter table DropIndex drop index BookId ;