Multiple choice technology databases

The SQL statement used to delete a table:

  1. DROP

  2. DELETE

  3. TRUNCATE

  4. All the Above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The statement asks which SQL statement deletes a TABLE (not data). DROP TABLE completely removes the table structure and data from the database. DELETE removes rows but keeps the table, TRUNCATE removes all rows but keeps the table structure. Only DROP removes the table itself.

Keep practicing — related questions