mysql

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?