---
title: "Add a column of zeros to table sql server"  
description: "Add a column of zeros to table sql server"  
author: "Anonymous User"  
published: 2013-05-04  
updated: 2013-05-04  
canonical: https://www.mindstick.com/forum/809/add-a-column-of-zeros-to-table-sql-server  
category: "c#"  
tags: ["c#"]  
reading_time: 1 minute  

---

# Add a column of zeros to table sql server

Hi Everyone!\
\
I have a [table in sql](https://www.mindstick.com/forum/205/find-the-all-column-with-schema-for-any-table-in-sql-server) [server](https://www.mindstick.com/articles/43769/what-is-serverless-architecture-is-it-worth-switching-over), but want to add a [extra](https://www.mindstick.com/blog/63570/5-ways-to-make-money-with-the-extra-space-in-your-home) [column](https://www.mindstick.com/forum/33860/how-to-calculate-column-summary-in-sql-server) [full](https://www.mindstick.com/articles/12893/experience-the-full-power-of-suitecrm) of zeros\
\
What would be the best [approach](https://www.mindstick.com/interview/985/what-are-the-approaches-that-you-will-follow-for-making-a-program-very-efficient) to do this\
\
att1 att2\
---------\
1.0 5.8\
2.7 3.8\
[5.1](https://answers.mindstick.com/qa/92571/how-to-work-bluetooth-5-1) 6.8\
becomes\
\
att1 att2 extra\
----------------\
1.0 5.8 0.0\
2.7 3.8 0.0\
5.1 6.8 0.0\
\
\
Thanks in [advance](https://www.mindstick.com/blog/33258/jee-mains-and-jee-advance-exams)!

## Replies

### Reply by AVADHESH PATEL

Hi Chintoo!\
you can try as following approach \
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 {DEFAULT_VALUE}\
I hope it resolve your problem!


---

Original Source: https://www.mindstick.com/forum/809/add-a-column-of-zeros-to-table-sql-server

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