---
title: "Add New Column in Table in SQL Server"  
description: "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].[EmpI"  
author: "AVADHESH PATEL"  
published: 2012-12-30  
updated: 2014-09-18  
canonical: https://www.mindstick.com/blog/417/add-new-column-in-table-in-sql-server  
category: "database"  
tags: ["database"]  
reading_time: 1 minute  

---

# Add New Column in Table in SQL Server

In this [blog](https://www.mindstick.com/articles/12705/myths-and-misconception-about-blog) I have described how to add new column in [existing table](https://www.mindstick.com/forum/157761/how-to-add-a-column-with-a-default-value-to-an-existing-table-in-sql-server). 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](https://www.mindstick.com/forum/811/alter-table-with-a-default-sql-server-vs-oracle) <Table Name> ADD <New [Column Name](https://www.mindstick.com/forum/369/how-can-i-add-a-column-name-to-my-grid)> <[Data](https://www.mindstick.com/articles/13050/salesforce-aiming-to-dominate-predictive-analytics-with-data-science) Type> <[Size](https://www.mindstick.com/forum/159799/how-can-you-manage-the-size-of-mdf-and-ldf-files)>

\

##### Example:

\

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

---

Original Source: https://www.mindstick.com/blog/417/add-new-column-in-table-in-sql-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.