When you are modifying table columns in SQL example changing data type or adding a new column, after you click save you are prompted with this error: "The changes you have made require the following tables to be dropped and re-created" from SQL Server."

To solve this issue you must do the following:

• Go to Tools, and select Options
• Select designer in the pop-up window
• Uncheck Prevent saving changes that requires table re-creation
• Click OK