remove primary key constraint mysql code example

Example 1: remove primary key from a table

alter table Player DROP PRIMARY KEY;

Example 2: mysql remove foreign key constraint

ALTER TABLE jobs DROP FOREIGN KEY constraint_name