The error is something like below:

Solution:

WARNING: All data in the table will be wiped, make sure to select the option again when done so nothing bad happens in another environment

1. Go to Tools
2. Then Options
3. Designers → Table and Database Designers
4. Uncheck Prevent saving changes that require table re-creation