I was trying to save my existing table but when I click to save an error message suddenly appears which you can see in the below attached image. Any idea? I need the assistance of anyone.
Post-save Notifications
Errors were encountered during the save process. Some data objects were not saved.
Unable to create index
Timeout expired. The timeout period elapsed prior to completion of the operation or the Could not create constraint. See previous errors.
Errors were encountered during the save process.
Hi Dominic D Beaton,
Well this problem occurs due to default saving changes to the table that required table re-creation which is disabled.
You need to enable this option to allow save changes to table re-creation.
You need to follow some simple steps.
-
Open the MYSql Server Management Studio.
-
Click on the tool tabs after click on the Options.
-
A new window will open and on the left side click on the Designers option.
-
Now on the right side “Table Option” screen will be displayed.
-
Check the last option in Table Option section and then click ok.
-
After saving these settings you problem will definitely solve, Best of Luck.
Regards,
Joshua Y Roush