18 reputation
6
bio website
location Denmark
age 30
visits member for 2 years, 2 months
seen Jul 23 at 20:51

Feb
17
awarded  Popular Question
Aug
1
awarded  Supporter
Aug
1
comment Why does altering a table and adding a foreign key create an extra constaint?
I figured that out, but thanks for the explanation.
Jul
31
awarded  Editor
Jul
31
revised Why does altering a table and adding a foreign key create an extra constaint?
added 399 characters in body
Jul
31
comment Why does altering a table and adding a foreign key create an extra constaint?
The name gives it all away, but I've not worked with sql-server much, so it's all learning. For the curious I edited the question with the solution.
Jul
31
awarded  Scholar
Jul
31
accepted Why does altering a table and adding a foreign key create an extra constaint?
Jul
31
comment Why does altering a table and adding a foreign key create an extra constaint?
I feel slightly stupid now. I added the extra column with a NOT NULL and DEFAULT statement, which of cause results in a constraint. Thanks for pointing me in the right direction.
Jul
30
awarded  Student
Jul
30
asked Why does altering a table and adding a foreign key create an extra constaint?
Jul
30
awarded  Teacher