Fill in the blank:
______ command is used to remove primary key from the table in SQL.
(a)
update
(b)
remove
(c)
alter
(d)
drop
Answer:
The alter table command is used to remove the primary key from a table in SQL.
Syntax to remove the primary key:
ALTER TABLE table_name DROP PRIMARY KEY ;
So, the correct answer is (c).