Is there a way to alter the design without creating table from scratch?

Question

I'm creating a database in SQL Server Management Studio which contains some tables plus stored procedures, now I have set all relationship between all tables but I want to alter something in the design of some tables however it keeps telling me the changing you have made require the following table to be dropped and re-created.

Is the a way do alter the design without creating table from scratch ??

What are you trying to change exactly? – Andy May 19 '13 at 21:15 — Andy, May 19 '13 at 21:15
I want to change the identity specification . – Ahmed Saeed May 19 '13 at 21:19 — Ahmed Saeed, May 19 '13 at 21:19

score 3 · Accepted Answer · answered May 19 '13 at 21:15

3

Turn off this option here (under the Tools > Options menu in SSMS) and you'll be able to make your changes:

enter image description here

It's checked (and thus activated) by default after installation.

answered May 19 '13 at 21:15

marc_s

732,580
175
1,330
1,459

score 0 · Answer 2 · answered May 19 '13 at 21:28

0

Yes, you can often issue an ALTER TABLE statement against the database even when SQL Management Studio believes that table recreation is required.

answered May 19 '13 at 21:28

Larry Lustig

49,320
14
110
160

Is there a way to alter the design without creating table from scratch?

2 Answers2