Question

______ command is used to remove the primary key from a table in SQL.

Options

• update

• remove

• alter

• drop

Answer 1

Alter command is used to remove the primary key from a table in SQL.

Explanation:

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 Alter.