All geek questions in one place

SQL Server intellisense does not update list of stored procedures and functions

I am trying to learn Microsoft SQL Server 2014. I have defined some functions and stored procedures, but the intellisence SQL server does not show the latter and emphasizes them as an error.

enter image description here

Although the SQL server shows as a runtime error, it works fine. My question is why the SQL server emphasizes the statement, even if it works.

enter image description here

+6
source share
2 answers

This will happen every time you create a new table, procedure, function, etc. or modify the database object (for example, add / remove columns in the table).

You just need to update your Intellisense cache to look for new objects. ctrl+shift+r should do the trick or use the menu option Edit > Intellisense > Refresh Local Cache as one of the suggested comments

enter image description here

+11
source

To update intellisense to include your latest stored procedures or table changes:

  • Open any stored procedure (right-click and select "Modify").
  • From the menu, choose Edit> Intellisense> Refresh Local Cache.

That should do it!

+3
source

Source: https://habr.com/ru/post/970583/

More articles:


All Articles