Chrome Extension

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;
We are a bunch of lazy programmers so we developed this chrome extension
search code from your favorite search engine
Install Now

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
Open Code Manager We are hiring