Interview Question

What is DROP TABLE?

DROP TABLE removes the table object and its data.

💡 Concept ✅ Quick Revision 🗃️ SQL

Answer

DROP TABLE removes a table definition and its stored rows. • Dependent objects can prevent the operation unless dependency behavior is specified. • DROP TABLE is different from DELETE because the table itself disappears. • Use destructive schema statements only with deliberate backup and permission controls.

💡 SQL Example

DROP TABLE old_import;

Result

DROP TABLE

⚡ Quick Revision

DROP TABLE removes the table object and its data.

←

PreviousWhat is ALTER TABLE?

NextWhat is JOIN in SQL?

→