Search code snippets, questions, articles...

Delete a column from Table MySQL

You can remove a column from a table using the DROP COLUMN statement in MySQL/SQL
ALTER TABLE Students
DROP COLUMN Email;

DROP COLUMN statement will completely remove a column from a table along with rows that exist in that column. For example, if there is a table named 'Employee' which has a column FirstName. If you want to remove this column from the table you can run the below query.

ALTER TABLE Employee
DROP COLUMN FirstName;
Was this helpful?
0 Comments
Programming Feeds
Learn something new everyday on Devsheet