SQL 2008 在Management Studio 中直接更改Schema會發生警告

透過 Management Studio 對已經開好的 Table 更改schema,
會警告說不允許這樣更改, 需要 re-create table 後才可以更改

「"Saving changes is not permitted. The changes you have made require the following tables 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."」

其實錯誤訊息裡就有提示, 要 " enabled the option Prevent saving changes that require the table to be re-created".

那這個選項在哪裡呢 ?

請到 SQL 2008 Management Studio 中

「Tools」-> 選「Options」=>
「Designers」-> 「Table and Database Designers」
，右側中將「Prevent saving changes that require table re-creation」選項打勾拿掉，就可以了！