delete column

How to Delete A Column in SQL?

ALTER TABLE table DROP COLUMN column query is used to delete a column in SQL. And to remove multiple columns from a table in the database, separate the first query by comma and use the DROP keyword and after it the second column name, etc.

Delete Single Column

ALTER TABLE admission DROP COLUMN fee;

Delete multiple columns

ALTER TABLE result DROP column_1, DROP column_2;

Leave a Comment