Alter Table Statement in MySQL : How to Drop Column in Table

In this article I will show you how to drop column in table.

DROP COLUN IN A Table

Syntax

Follow the below syntax to drop column in a table using MySQL Ater Table Statement.

ALTER TABLE table_name
  DROP COLUMN column_name;

Where;

• table_name : Name of the table to modify.
• new_column_name : Name of the column to from the table.

Example

Let’s see how to we can drop a column in MySQL table using the ALTER TABLE Statement.

ALTER TABLE contacts
  DROP COLUMN contact_type;

In above example Alter Table example will drop the column called contact_type from the table called contacts.