Which SQL command is used to remove a table from a database?
2023
Which SQL command is used to remove a table from a database?
- A.
DELETE
- B.
DROP
- C.
ERASE
- D.
More than one of the above
- E.
None of the above
Attempted by 1842 students.
Show answer & explanation
Correct answer: B
To remove a table from a database, we need a command that deletes the table structure and all its data. Let's analyze each option: Option A: DELETE is used to remove specific rows from a table, not the entire table. It does not remove the table structure, so it is not correct. Option B: DROP is the SQL command used to remove a table from a database. It deletes the table structure and all associated data. This command is specifically designed for removing tables. Option C: ERASE is not a standard SQL command. It is not recognized in SQL syntax for database operations, so this option is invalid. Option D: This option claims that more than one of the above commands can be used. However, only DROP is correct. Therefore, this option is incorrect. Option E: This option says none of the above are correct. But since DROP is a valid command for removing a table, this option is incorrect.