Updating SQL intellisense

So you added a new table / field via D365 Finops and synchronised the database.
To get the intellisense to pick those new objects you might be restarting SSMS ?

Instead you could just be refreshing the intellisense OR in other words Refresh intellisense’s local cache

  1. Create a new query window and link it to your database
  2. Click on Edit > Intellisense > Refresh local cache (Ctrl + Shift + R)

You will now have the new objects.

Enjoy !

Leave a Reply / Comment

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.