Tip of the Day : How to Join with an Inline User-Defined Function

SQL Server Helper - Tip of the Day

How to Refresh Intellisense

IntelliSense functionality does not cover database objects created by another connection after your editor window connected to the database.  If objects added on other connections are missing from features like completion lists, you can choose one of these three mechanisms to refresh the cache of objects for your editor window:

- Select the Edit menu, select IntelliSense, then select Refresh Local Cache.
- Use the CTRL+Shift+R keyboard shortcut.
- Disconnect your editor window from the instance of the Database Engine and reconnect.

Back to Tip of the Day List Next Tip