Question - Can a primary key be dropped in MySQL? If yes, how?
Answer -
Yes, it is possible to drop the primary key from a table. The command to use is again, the ALTER TABLE followed by DROP. It goes like this:
ALTER TABLE table_name DROP PRIMARY KEY;