Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
midpitts
Starting Member
12 Posts |
 Posted - 2012-04-11 : 11:58:59
|
| I am a student and I have a problem. I created a couple of tables and then decided I didn't need these tables afterall. I deleted them and went on to creat the rest of my database in the diagram view. I am trying to save the diagram ( thereby creating the new tables) but the system says I can't save because of the two previously created and deleted tables have been changed. error message:"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 recreated or enabled the option Prevent saving changes that require the table to be re-created." How can I fix this without having to redo all my work.Thanks for your help.Diane |
|
|
midpitts
Starting Member
12 Posts |
Posted - 2012-04-11 : 12:04:11
|
| Found the solution right after I posted this. This is by design and can be quickly fixed in Management Studio by unchecking a property. To fix this in Management Studio, go to Tools -> Options then go to the Designer Page and uncheck "Prevent saving changes that require table re-creation". |
 |
|
|
|
|
|
deleting tables