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) |
