In this tutorial we are going to see how to remove the column from table .If we want to remove column from table , we have to use DROP with ALTER keyword . See the below syntax .

Syntax :

ALTER TABLE table_name
DROP COLUMN column_name

Example :

ALTER TABLE student
DROP COLUMN student_adrees;

Remember, all the queries are written Oracle/MySql databases perspective only . Some databases may not support to delete columns