Which SQL command is used to remove a table from a database?

• A. DROP
• B. DELETE
• C. ALTER
• D. TRUNCATE

Answer: (A)

The SQL command used to remove a table from a database is "DROP." When you execute the DROP command on a table, it permanently deletes both the table structure and all the data contained within it. This action cannot be undone, making it important to use this command with caution.

The other commands serve different purposes:

• "DELETE" is used to remove specific rows from a table based on a condition, but it does not remove the table itself.

• "ALTER" is designed to modify an existing table's structure, such as adding or dropping columns, but it does not remove the table entirely.

• "TRUNCATE" is used to remove all rows from a table quickly and efficiently without logging individual row deletions, but the table structure remains intact.

Thus, the DROP command is specifically intended for the complete removal of a table from the database.