_______ command is used to remove a relation from SQL database.
2018
_______ command is used to remove a relation from SQL database.
- A.
Drop table
- B.
Delete table
- C.
Remove table
- D.
Update table
Attempted by 1328 students.
Show answer & explanation
Correct answer: A
Answer: DROP TABLE
Explanation: The DROP TABLE command removes the table definition and all its data from the database.
Syntax example: DROP TABLE table_name;
DELETE removes rows from a table (e.g., DELETE FROM table_name WHERE ...), but does not remove the table structure.
There is no standard SQL command named "REMOVE TABLE"; use DROP TABLE to remove the table itself.
UPDATE changes existing rows and does not delete the table.
Note: DROP TABLE is a DDL operation. Depending on the DBMS and transaction settings, it may not be reversible.
A video solution is available for this question — log in and enroll to watch it.