Thanks, but if I have data, doesn't this (when un-checked) dump the data when the table is re-created?
>Greg,
>
>You may just need to go to Tools | options | expand "Designers" and click on "Table and Database Designers" and then on the right un-check "Prevent Saving changes that require table re-creation"
>Tim
>
>>I have been learning SQL 2008. After creating a few related tables, I added a few additional column to one of the tables. When I attempt to save the table structure I get an error telling me that the table can not be dropped and re-created.
>>
>>1. Why when added a new column does SQL need to drop the original and re-create it?
>>
>>2. If the constraint are the problem, why doesn't SQL drop the constraints and recreate them?
Greg Reichert