Chrome Extension
MySQL Basics
MySQL
or Create new Snippet

Delete a column from Table MySQL

mysql Share on :
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?
Created by :

@
user image Write your Comment
0 Comments
🤔 Similar code snippets
Find us at:
Open Code Manager We are hiring