R
R
RadeG2017-06-19 02:14:06
Microsoft SQL Server Management Studio
RadeG, 2017-06-19 02:14:06

Is there a setting in Microsoft SQL SMS to instantly read changes to a DBMS instance?

After creating any objects (tables, views, adding/deleting columns, etc.) in the database, these objects are considered by the Microsoft SQL Server Management Studio editor as non-existent and it marks any queries with their participation in red with a corresponding error.
Queries involving these new objects work, but when debugging large queries, you constantly have to restart Microsoft SQL Server Management Studio, which is wildly inconvenient. A quick google search turned up no results.
Maybe there is a corresponding setting in Microsoft SQL Server Management Studio responsible for re-caching the list of actual database objects?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Andrey Skorzhinsky, 2017-06-19
@RadeG

In 2016 studio ctrl-shift-r - refresh local cache

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question