SQL Server Error: Saving Changes is not permitted. The changes you have made require the following tables to be dropped and recreated

you got error while you save any changes structure of tables.the error something like this

when you install the microsoft SQL Server management studio, the default settings do not allow you to save any changes to the structure of your tables that would cause the tables to be dropped and created.

following these simple steps to change this setting:

1. Open SQL Server Manaagement Studio.
2. From the file menu, choose Tools a Options.
3. From the left menu, choose Designers.
4. Uncheck the box entittled prevent saving changes that require table re-creation.
5. Press Ok to save.

thats it.