---
title: "How to set default value for all tables column in SQL Server?"  
description: "How to set default value for all tables column in SQL Server?"  
author: "Anonymous User"  
published: 2013-05-04  
updated: 2013-05-04  
canonical: https://www.mindstick.com/forum/812/how-to-set-default-value-for-all-tables-column-in-sql-server  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# How to set default value for all tables column in SQL Server?

Hi!\
\
How to set [default value](https://www.mindstick.com/forum/2035/default-value-when-using-singleordefault) for all [tables](https://www.mindstick.com/articles/336597/introduction-of-html-tables-for-web-development) [column in SQL](https://www.mindstick.com/forum/34026/how-to-insert-values-to-identity-column-in-sql-server) [Server](https://www.mindstick.com/articles/43769/what-is-serverless-architecture-is-it-worth-switching-over)?\
\
If it is [string](https://www.mindstick.com/articles/1527/string-split-in-c-sharp) it will empty and if it is int in [already](https://yourviews.mindstick.com/view/88453/the-hidden-ways-ai-is-already-controlling-your-daily-life) created table.\
\
Thanks in [advance](https://www.mindstick.com/blog/33258/jee-mains-and-jee-advance-exams)!

## Replies

### Reply by AVADHESH PATEL

Hi Jayprakash!\
Add [DEFAULT](https://www.mindstick.com/interview/12771/what-is-the-importance-of-default-resources) constraint\
Here is the way to do it:\

```
CREATE TABLE Persons(id int NOT NULL,LName varchar(25) NOT NULL,FName varchar(25),Addr varchar(255),City varchar(255) DEFAULT 'Hawaii')
```

\
I hope it solve your problem!\


---

Original Source: https://www.mindstick.com/forum/812/how-to-set-default-value-for-all-tables-column-in-sql-server

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