forum

Home / DeveloperSection / Forums / Alter Table

Ask Question

Alter Table

Jack C308029-Sep-2010
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
mssql servermssql server 
Updated on 21-Mar-2017
Jack C

Jack C

Follow

Can you answer this question?

Answer

3 Answers

Anonymous User

Anonymous User

21-Mar-2017

To add a column to an existing table, the ALTER TABLE syntax is:

ALTER TABLE table_name
 ADD column_name dataType

For example:

ALTER TABLE User
 ADD Name  varchar(50);

Uttam Misra

Uttam Misra

03-Oct-2010

To add a column to an existing table, the ALTER TABLE syntax is:

ALTER TABLE table_name
 ADD column_name column-definition;

For example:

ALTER TABLE employee
 ADD employee_name  varchar(50);

This will add a column called employee_name to the Employee table.

Amit Singh

Amit Singh

30-Sep-2010
we add the new column in a table by using alter command as
alter table tablename add columnname datatype constraints


alter table tablename add newLocation varchar(30), oldCityName varchar(20)



Liked By