mysql foreign key used as primary key code example Example: drop foreign key ALTER TABLE table_name DROP CONSTRAINT fk_name;