Suggest an editImprove this articleRefine the answer for “How do you drop a column from a table?”. Your changes go to moderation before they’re published.Approval requiredContentWhat you’re changing🇺🇸EN🇺🇦UAPreviewTitle (EN)Short answer (EN)Dropping a column from a table is done with `ALTER TABLE` and the `DROP COLUMN` clause, e.g. `ALTER TABLE Employees DROP COLUMN Salary;` - the data in that column is irreversibly lost. **Key point:** some DBMSs let you drop several columns in a single query, but the command should be used carefully, since the data can't be recovered without a backup.Shown above the full answer for quick recall.Answer (EN)ImageDropping a column from a table is done with the `ALTER TABLE` command and the `DROP COLUMN` clause. **Syntax:** ```sql ALTER TABLE Table_Name DROP COLUMN Column_Name; ``` **Example:** ```sql ALTER TABLE Employees DROP COLUMN Salary; ``` **Explanation:** - `ALTER TABLE Employees`, picks the table we want to change. - `DROP COLUMN Salary`, drops the `Salary` column along with all its data. ### Notes - Once a column is dropped, its data is **irreversibly lost**. - Some DBMSs let you drop several columns in a single query: ```sql ALTER TABLE Employees DROP COLUMN Salary, DROP COLUMN HireDate; ``` > The takeaway: this command should be used carefully, 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.