Machine-translated by Google. Questions are authored in English.
Top

Discussion

The DROP TABLE statement:

  • A.deletes the table structure only.
  • B.deletes the table structure along with the table data.
  • C.works whether or not referential integrity constraints would be violated.
  • D.is not an SQL statement.

Answer: B

Correct answer: deletes the table structure along with the table data.

DROP TABLE removes the table entirely: definition, data, indexes and constraints together. It is quite different from DELETE, which removes rows and leaves the table in place. It also fails if a foreign key elsewhere still references the table, since dropping it would break referential integrity.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.