sql server 2008 R2 management studio table recreation

Question

I created tables in sql server 2008 R2 with management studio. Now I want to modify some of my tables, but I cannot do that, It's says my modification needs table recreation, any suggestion?

score 3 · Accepted Answer · answered Sep 07 '13 at 14:59

3

I've found my answer tools->options->designers->Table and database designers" and unchecking "Prevent saving changes that require table re-creation"

answered Sep 07 '13 at 14:59

score 2 · Answer 2 · answered Sep 07 '13 at 14:57

2

Tools, Options, Designers -> Checkbox "Prevent saving changes that require table re-creation".

answered Sep 07 '13 at 14:57

NickD

2,672
7
37
58

sql server 2008 R2 management studio table recreation

2 Answers2