How to Drop a Column in MySQL

This example deletes the column my_column of table my_table:

ALTER TABLE my_table
DROP COLUMN my_column;
Previous
How to Add a Column in MySQL
Next
How to Rename a Column in MySQL

Get started with DB Pilot

DB Pilot is a Database GUI client and SQL editor for PostgreSQL, MySQL, SQLite, DuckDB & more.

Download Learn more