TechnoLearnAcademy

TECHNOLEARN

SQL ADD COLUMN

The ALTER TABLE Statement is used to add a new Column to an existing table.

Syntax:      

                   ALTER TABLE  table_name 
                   ADD column_name datatype;

Example:

   Objective: In this example, we will add a new column Dept to to the Emp table. 
                    ALTER TABLE Tbl_Emp
                    Add Dept varchar(20);
Scroll to Top