How to delete the column from MySQL

In this post we will see how we can delete the column from MySQL.

Column can be deleted from the MySQL table by using the Alter statement. Use drop keyword to delete the column from MySQL.

Syntax to delete column from MySQL table

Alter table table_nm Drop column_nm;

Alter table dept drop owner;

In this example, owner column will be deleted from the Dept table.