gigi gigi - 5 months ago 82
SQL Question

Cannot modify table ( using microsoft sql server management studio 2008 )

I create 2 tables and another 1 with foreign keys to the other two.

I realized I want to make some changes to table no 3.

I try to update a field but I get an error "Saving changes is not permitted. The changes you have made require the following table to be dropped and re-created."

I delete those 2 relationships but when I look at dependencies I see my table still depends on those 2 and I still cannot make any change to it.

What can I do?

Answer Source

You can also enable saving changes that require dropping of tables by going to "tools->options->designers->Table and database designers" and unchecking "Prevent saving changes that require table re-creation"

Be careful with this though, sometimes it'll drop a table without being able to recreate it, which makes you lose all data that was in the table.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download