📘Introducing SQL Notebooks: Tell stories using data.Read more →
Sign In

How to Drop a Column in MySQL

Dropping a column in MySQL involves using the ALTER TABLE command. The typical syntax is as follows:

ALTER TABLE table_name DROP COLUMN column_name;

--The COLUMN keyword is actually optional
ALTER TABLE table_name DROP column_name;

Previous

How to Add a Column

Next

How to Rename a Column

Ready for a modern SQL editor?

Get started for free