---
title: "Add column, with default value, to existing table in SQL Server"  
description: "Add column, with default value, to existing table in SQL Server"  
author: "Anonymous User"  
published: 2013-04-17  
updated: 2013-04-17  
canonical: https://www.mindstick.com/forum/771/add-column-with-default-value-to-existing-table-in-sql-server  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# Add column, with default value, to existing table in SQL Server

Hi Everyone!\
How do you add a [column](https://www.mindstick.com/forum/33860/how-to-calculate-column-summary-in-sql-server), with a [default value](https://www.mindstick.com/forum/2035/default-value-when-using-singleordefault), to an [existing table](https://www.mindstick.com/forum/156738/how-to-add-and-remove-columns-from-an-existing-table-in-the-database) in [SQL Server](https://www.mindstick.com/articles/12999/what-is-table-valued-function-in-sql-server) 2000/2005?\
Thanks in [advance](https://www.mindstick.com/blog/33258/jee-mains-and-jee-advance-exams)!

## Replies

### Reply by AVADHESH PATEL

Hi Ashish!\
You can try as below\
ALTER [TABLE](https://www.mindstick.com/articles/43918/how-to-design-table-using-bootstrap) {TABLENAME} ADD {COLUMNNAME} {TYPE} {NULL|NOT NULL} CONSTRAINT {CONSTRAINT_NAME} [DEFAULT](https://www.mindstick.com/interview/12771/what-is-the-importance-of-default-resources) {DEFAULT_VALUE}\
I hope it resolve your problem


---

Original Source: https://www.mindstick.com/forum/771/add-column-with-default-value-to-existing-table-in-sql-server

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