How to refresh Intellisense in SQL Server Management Studio (SSMS)

When we create or change an object in SQL Server Management Studio, the IntelliSense often doesn’t know about these changes. This is because we need to refresh the SSMS Intellisense cache.

We can do this in SQL Server Management Studio / SSMS using the below menu item or the Ctrl+Shirt+R shortcut…

Refresh intellisense SSMS


You might also be interested in...

How to cycle through the clipboard ring in SQL Server Management Studio
Posted this before about Visual Studio, but in SQL Server Management Studio, CTRL+V will paste the LAST COPIED item but … Continue reading How to cycle through the clipboard ring...

Use Registered Servers in SQL Server Management Studio (SSMS) for easy access to multiple DB servers
Switching between multiple DB servers in SQL Server Management Studio can be a pain. Registered Servers in SQL Server Management … Continue reading Use Registered Servers in SQL Server Management...

Showing line numbers in SQL Server Management Studio
Line numbers are not displayed by default in SQL Server Management Studio (SSMS) but… they are super helpful if you’re … Continue reading Showing line numbers in SQL Server Management...

How to set SQL Server Management Studio (SSMS) transaction isolation level
The default transaction isolation level for queries ran from SQL Server Management Studio is read committed. Occasionally this can cause … Continue reading How to set SQL Server Management Studio...

Create insert statements for existing data in tables from SQL Server Management Studio (SSMS)
At lot of us will have used the ‘Generate Scripts‘ functionality in SQL Server Management Studio (SSMS) to export schema … Continue reading Create insert statements for existing data in...

Leave a Reply

Your email address will not be published. Required fields are marked *