Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 36 of 79

Table Creation and Data Manipulation Commands — Question 10

Back to all questions
10
Question

Question 10

Fill in the blank :

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

  1. update
  2. remove
  3. alter
  4. drop
Answer

alter

Reason — To remove a primary key constraint from a table the ALTER command is used. The DROP clause of ALTER TABLE command is used with syntax ALTER TABLE <TABLENAME> DROP PRIMARY KEY ;.