I have a table which contains 23 columns now due to project requirement I have to add few more columns in the existing table.
Column name like newLocation, oldCityName.
If possible provide me sample of code to add columns in a table.
Thanks in advance
Alter Table
Updated 21 Mar 2017
To add a column to an existing table, the ALTER TABLE syntax is:
For example:
To add a column to an existing table, the ALTER TABLE syntax is:
For example:
This will add a column called employee_name to the Employee table.
alter table tablename add columnname datatype constraints
alter table tablename add newLocation varchar(30), oldCityName varchar(20)