how to remove a column from being a unique key code example Example: remove unique key from a table example: alter table DropIndex drop index BookId ;