When working on SQL Server Management Studio, when any new tables are created or columns are added, the local cache is not refreshed immediately and display as error for the new objects or columns in the Query Window. To avoid this we need to update local cache of SSMS.
If you need to refresh the local cache of SSMS you can use two methods
First Method:
Press the following combination of keys on your keyboard by selecting SSMS
CTRL + Shift + R
Second Method:
Select the Query window in SSMS
In the Edit Menu
Go to IntelliSense
Press on Refresh Local Cache
No comments:
Post a Comment