Tip of the Day : How to Get a List of Databases Within a SQL Server Instance

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