This is a very common issue we face in SQL server management.
We can fix this issue in two ways
- Dropping the table and recreate it
- Modifying the Settings in SSMS
SSMS Setting:
In few clicks, we can enable the setting
- Click on the tools from menu bar
2. Select the Options from the list
3. After Clicking on the Options, Select the Designers option
There is one checkbox – Prevent saving changes that require table re-creation, If it is checked then uncheck it and click on OK. These changes are enough to fix this issue.
Need help?
Read this post again, if you have any confusion or else add your questions in Community