If you try to change columns in a table that you've created you will get the following message:
"Saving changes ins not permitted. The changes you have made require the following table to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.". I think this option isen't very useful as enabled by default.
The message explains itsel, you have to disable the "Prevent saving changesthat require the table to be re-created", but where is this option.
Tools -> Options -> Table and Database Designers -> Uncheck "Prevent saving changes that require the table to be re-created"
No comments:
Post a Comment