_______ command is used to remove a relation from SQL database.

2018

_______ command is used to remove a relation from SQL database.

  1. A.

    Drop table

  2. B.

    Delete table

  3. C.

    Remove table

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

Explore the full course: Mppsc Assistant Professor