Site icon SmartTutorials.net

Delete a column from an existing MySQL table

Drop column MySql command used to delete a column from an existing MySQL table.

MySql Logo

Syntax for deleting particular column for the able is :

ALTER TABLE tablename DROP column-name

for example

ALTER TABLE moviesite DROP movie_name

where

moviesite  – Table name

movie_name – Column name.

Exit mobile version