Alex Rivera | Logout

Intellisense not updating in Sql Server

Asked 2011-03-14T04:12:08.767
19

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 made?

Edit
Report

1 Answer

0

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

answered 2011-03-14T04:16:45.257

Your Answer