Multiple choice technology databases

Which key word is used to remove a table from the database

  1. Delete

  2. Truncate

  3. Remove

  4. Drop
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

DROP TABLE is the SQL command that removes a table definition and all its data from the database. DELETE removes only data, TRUNCATE removes all data but keeps the table structure, and REMOVE is not a standard SQL command.

Keep practicing — related questions