blog

Home / DeveloperSection / Blogs / Add New Column in Table in SQL Server

Add New Column in Table in SQL Server

AVADHESH PATEL3300 30-Dec-2012

In this blog I have described how to add new column in existing table. For demonstration I have used a table that given below.

CREATE TABLE [dbo].[EmpInfo]
(
[ID] INT IDENTITY PRIMARY KEY,
[Name] VARCHAR(50),
[Date] VARCHAR(50)
)


Syntax :

ALTER TABLE <Table Name> ADD <New Column Name> <Data Type> <Size>


Example:



ALTER TABLE [dbo].[EmpInfo]
ADD [Address] VARCHAR(200)

Updated 18-Sep-2014
Avadhesh Kumar Patel District Project Manager - Aligarh 14 months work experience in Panchayati Raj Department Sector as District Project Manager & 12 months work experience in IT Sector as Software Engineer. :-)

Leave Comment

Comments

Liked By