By default, if you try to change a table using the designer making any of the following changes, you get an error message:
- You change the Allow Nulls setting for a column.
- You reorder columns in the table.
- You change the column data type.
- You add a new column.
I know that one can turn this off by changing the "Prevent saving changes that require table re-creation' option in SSMS options.
I find that for some tables, (the ones with important data in them), I want this warning. However, for a lot of other tables, I don't care whether they get blown away and then re-created. Right now, I'm just constantly changing the setting back and forth, but what I'd really like is a way to be warned but still be given the option to proceed anyway.
Is there any setting anywhere that would cause behaviour like this?