Database

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.

Thank you! for visiting LookLinux.

If you find this tutorial helpful please share with your friends to keep it alive. For more helpful topic browse my website www.looklinux.com. To become an author at Look Linux Submit Article. Stay connected to Facebook.

About the author

mm

Santosh Prasad

Hi! I'm Santosh and I'm here to post some cool article for you. If you have any query and suggestion please comment in comment section.

Leave a Comment