Which SQL command is used to remove a table?
2026
Which SQL command is used to remove a table?
Answer: C. DROP — ConceptSQL statements are grouped by the kind of database object or data they affect. Data Definition Language (DDL) changes the database schema, whereas Data…
- A.
DELETE
- B.
REMOVE
- C.
DROP
- D.
ERASE
Attempted by 56 students.
Show answer & explanation
Correct answer: C
Concept
SQL statements are grouped by the kind of database object or data they affect. Data Definition Language (DDL) changes the database schema, whereas Data Manipulation Language (DML) changes the rows stored within that schema.
A table is a schema object. Removing the table itself therefore requires a DDL statement, not a row-manipulation statement.
Application
DROP TABLE removes the named table definition from the database. Therefore, the command represented by DROP is the required command.
Contrast and cross-check
DELETE removes rows selected from an existing table but keeps the table structure.
REMOVE is not a standard core SQL statement for deleting a table.
ERASE is not a standard core SQL statement for deleting a table.
Hence, the answer is DROP.