To avoid this error message follow below Steps:
Go To Tools-> Option in From Menu Items.
Select Designers -> Table and DataBase Designers from Left Panel -> Make sure Prevent saving changes that require table re-creation is UnChecked.