Suggest an editImprove this articleRefine the answer for “How do you drop a table?”. Your changes go to moderation before they’re published.Approval requiredContentWhat you’re changing🇺🇸EN🇺🇦UAPreviewTitle (EN)Short answer (EN)`DROP TABLE` is used to delete a table in SQL - it completely removes the table along with all its data and structure, and the data can't be recovered without a backup. **Key point:** if a table has relationships via foreign keys, some DBMSs will require those relationships to be removed first, or `CASCADE` to be used to remove dependent objects.Shown above the full answer for quick recall.Answer (EN)Image`DROP TABLE` is used to delete a table in SQL. It completely removes the table along with all its data and structure. **Syntax:** ```sql DROP TABLE Table_Name; ``` **Example:** ```sql DROP TABLE Employees; ``` ### Important - Once the command runs, every piece of data in the table is **irreversibly deleted**. - If a table has relationships via foreign keys, some DBMSs will require those relationships to be removed first, or `CASCADE` to be used to remove dependent objects. An example with removing dependent objects (PostgreSQL): ```sql DROP TABLE Employees CASCADE; ``` > The takeaway: `DROP TABLE` is used only once a table is no longer needed, since recovering the data will be impossible without a backup.For the reviewerNote to the moderator (optional)Visible only to the moderator. Helps review go faster.