Wednesday, August 26, 2009

If you want to change the structure of a table, by default SQL Management Studio prevents you from doing this if it require that the table be dropped and recreated.

TableCreation1

If you want to change this behaviour, from the Designers section in the Tools/Options menu, simply uncheck “Prevent saving changes that require table re-creation”.

TableCreation2

http://msdn.microsoft.com/en-us/library/bb895146.aspx

Wednesday, August 26, 2009 8:31:28 AM (Eastern Daylight Time, UTC-04:00)  #     | 
Bookmark and Share

Theme design by Jelle Druyts