To add new column in existing table, ALTER TABLE is used with ADD action with following syntax
Syntax:
ALTER TABLE table_name ADD column_name data_type constraint;
In this statement:
Points to Remember:
ALTER TABLE table_name ADD (column_name_1 data_type constraint, column_name_2 data_type constraint, ... column_name_n data_type constraint);
..