You want to remove a PRIMARY KEY you added to a column in an existing table. Which two SQL statements would you use to do this?

All Questions › Category: Database › You want to remove a PRIMARY KEY you added to a column in an existing table. Which two SQL statements would you use to do this?
-1 Vote Up Vote Down
Anonymous asked 3 years ago

Options:

  1. ALTER TABLE and DROP PRIMARY KEY
  2. ALTER TABLE and DROP CONSTRAINT
  3. INSERT TABLE and DROP CONSTRAINT

  4. INSERT TABLE and DROP PRIMARY KEY

1 Answers
0 Vote Up Vote Down
Anonymous answered 3 years ago
  1. ALTER TABLE and DROP CONSTRAINT