Add Column Syntax:
ALTER TABLE table_name
ADD column_name data_type
Employee table:
Column name | Data_type |
---|---|
id | int |
name | varchar(250) |
Add Column Example:
ALTER TABLE employee
ADD (dep_id int, address varchar(100));
Add Column Result:
Column name | Data_type |
---|---|
id | int |
name | varchar(250) |
dep_id | int |
address | varchar(100) |