Intellisense not updating in Sql Server

Given: A table named Table1 that has the following columns:

• ID
• ColumnA
• ColumnB

Typing Table1. in Microsoft SQL Server Management Studio provides me with a list of columns for that table.

Scenario:

I open up Table1 in the design view and add ColumnC to it. I save Table1 and refresh it to see the new column, Column3 show up in the Object Explorer.

Going back to the Query Window, I type Table1. but Column3 is not available to be selected. Typing it out gives me a syntax error but running a query with the column in it works as expected.

Is there a menu item somewhere that I need to click to get Intellisense to pick up the DDL changes I have ma开发者_如何学Pythonde?

Edit -> Intellisense - Refresh Local Cache

That should do it.

Ctrl-Shift-R is the shortcut.

In addition to refreshing the cache you also need to do the following if you haven't already:

Go to Tools >> Options >> Text Editor >> Transact-SQL >> General >> IntelliSense

Check the box Auto List Members and also the box Parameter Information save and restart.

I also highly recommend the Redgate SQL Toolbox if you regularly use SQL Server. SQL Compare and SQL Data Compare and the SQL Prompt5 have saved me lots of time in development.

I have to restart management studio when this happens. Refreshing object explorer doesn't update the intellisense.