How to Delete A Column in SQL?

Date Published: 11/03/2020Published By: JaiSchool

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

Leave a Reply

Your email address will not be published.