remove primay key contraint and give to another column code example Example: remove primary key from a table alter table Player DROP PRIMARY KEY;