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;
Publish A Comment