Computer Science - Class 12
Solutions to CBSE Sample Paper - Computer Science Class 12

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

 

Go Ad-free
Davneet Singh's photo - Co-founder, Teachoo

Made by

Davneet Singh

Davneet Singh has done his B.Tech from Indian Institute of Technology, Kanpur. He has been teaching from the past 14 years. He provides courses for Maths, Science, Social Science, Physics, Chemistry, Computer Science at Teachoo.