While working with SQL Server we may get below error :
Saving changes is not permitted. The changes you have made require that the following tables to dropped and recreate.
You have either made changes to the table that can’t be recreate or enable the option prevent saving changes that require the tables to be recreate.
We can disable above error message by SQL Server Environment settings
Follow below steps to configure SQL Server environment
Log in to SSMS
Navigate to
Tools – Options – Designers
Select Check box – Prevent saving changes that require the table re-creation
This option will help you in above error.