question

spatel avatar image
spatel asked

drop table and recreate, unable to save.

Hi I connected to database in SSMS, now am tring to add new column. I added columns and datatype but upon saving is asking to drop table and recreate.I cannot add new columns.
ssms
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
sp_lock avatar image
sp_lock answered
There is a warning setting within SSMS option. This could be stopping you. See attached screen shot![alt text][1]. "Prevent saving changes that req table re-creation". Personally, if I use SSMS for table change I like to script the changes and not actually use the GUI (as such) [1]: /storage/temp/657-options_2013-02-11_23-49-19.jpg

options_2013-02-11_23-49-19.jpg (52.5 KiB)
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

spatel avatar image spatel commented ·
Thank you Jon, resolved
0 Likes 0 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
Hi @spatel. If the answer has helped, then please vote it up and mark it as correct by using the thumbs up & tick icons at the top left of the answer.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.