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?

Answer: B. DROPTo 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…

  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 2599 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: Uppsc Polytechnic Lecturer 2025 Cs

Loading lesson…