0

Hee Guys,

I have not worked with this database tool but is it possible to set a default value for a column?

I want the default value to be 1 how can I achieve this. It think you have to change something in the properties.

Can you tell me how?

enter image description here

Senta
  • 193
  • 3
  • 16
  • Possible duplicate of [How to set a default value for an existing column](https://stackoverflow.com/questions/6791675/how-to-set-a-default-value-for-an-existing-column) – Filburt Sep 01 '17 at 11:41

1 Answers1

0

You can do that in two ways, by Management Studio GUI and by using t-sql. It described in following article, please check it out: https://technet.microsoft.com/en-us/library/ms187872(v=sql.110).aspx

Nikita V
  • 367
  • 4
  • 9