How to delete a column in SQL ?

To delete a column in SQL we will be using DROP COLUMN method:


ALTER TABLE employees
DROP COLUMN age;

We will start off by giving the keywords ALTER TABLE, then we will give the name of the table, following which we will give the keywords DROP COLUMN and finally give the name of the column which we would want to remove.

How to delete a column in SQL ?

Published on 16-Dec-2021 16:39:14

You may also like this!