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 !

Comment List