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?

  1. A.

    DELETE

  2. B.

    DROP

  3. C.

    ERASE

  4. D.

    More than one of the above

  5. 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.

Explore the full course: Up Lt Grade Assistant Teacher 2025