Mini Post: Saving changes is not permitted. The changes you have made require...

Hey Everyone! (Capital 'E' since you are all that important!)

Welcome to or welcome back to SQL Something!

A real quick one today to maintain my quota: Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created.

Fig. 1: Oh Noes!

You may encounter this error when you try to make adjustments to columns of a table that has data in it. Examples are dropping/adding a column(s).

Simple enough to 'fix'.



Go to "Tools -> Options"

Fig. 2: Going To Our Tools

Go to the 'Designers' tab, expand it and go to the "Table and Database Designers" section and de-select the last check-box: "Prevent saving changes that require table re-creation".

Fig. 3: Uncheck The Last Option

And that's it. :-)

DISCLAIMER: As stated, I’m not an expert so please, PLEASE feel free to politely correct or comment as you see fit. Your feedback is always welcomed. :-)