Which command is used to remove a relation from an SQL?
2025
Which command is used to remove a relation from an SQL?
- A.
Drop table
- B.
Delete
- C.
Purge
- D.
Remove
Attempted by 1187 students.
Show answer & explanation
Correct answer: A
In SQL, the command used to remove a relation (table) from the database is 'DROP TABLE'. This command deletes the entire table structure and all its data permanently. The 'DELETE' command removes rows from a table but does not remove the table itself. It is used to delete data, not the table structure. The 'PURGE' command is not a standard SQL command for removing tables. It is used in some database systems for recovery purposes, not for general table removal. The 'REMOVE' command is not part of standard SQL syntax. SQL does not have a 'REMOVE' keyword for deleting tables.