How to allow saving changes that require table re-creating

You may encouter an error message "Saving changes is not permitted. The changes you have made require the following tables to be dropped..." after you make changes to a table structure. To allow saving changes:

• In your SSMS, select Tools -> Options..., click Designers at the left menu, then uncheck the checkbox left to "Prevent saving changes that require table re-creation" on Table Options area at the right.

How to refresh the cache for IntelliSense

In your Query Editor window, you may encouter a red wave line indicating an object name is invalid even though you are sure that object, such as a column name, does exist in your database

• The reason for the error is that SSMS intelliSense keeps a cache of all database objects after the Query Editor window is open. If a new object is created after the window is open, that object is not in the cache.
• To remove the error, in SSMS, go to Edit -> IntelliSense -> Refresh Local Cache or hold these keys at the same time: Ctrl+Shift+R