TechnoLearnAcademy

TECHNOLEARN

SQL DROP COLUMN

The ALTER TABLE Statement is used to drop the existing column from a table.

Syntax:      

                   ALTER TABLE  table_name 
                   DROP COLUMN column_name ;

Example:

   Objective: In this example, we will drop dept column from the emp table. 
                    ALTER TABLE Tbl_Emp
                    DROP COLUMN Dept ;
Scroll to Top