Can a primary key be dropped in MySQL? If yes, how?
Yes, the primary key can be dropped in MySQL with the use of the “ALTER TABLE” statement.
Syntax:
ALTER TABLE table_name DROP PRIMARY KEY
BY Best Interview Question ON 04 Mar 2022
Yes, the primary key can be dropped in MySQL with the use of the “ALTER TABLE” statement.
Syntax:
ALTER TABLE table_name DROP PRIMARY KEY