x

Why doesn't new table show up in intellisense?

I've jut created a new table in a SQL Server 2008 database. I'm trying to write a stored procedure to insert data into this new table. One of the cool features I like in SQL 2008 is the intellisence built into the T-SQL designer. Anyway, when I type INSERT INTO then the Intellisense drop down doesn't present me with my new table. Even if I type in the name of the new table the the T-SQL designer gives me an error of "invalid object". I have made sure that the permissions on the new table and any of the other old tables is identical, but only the old tables appear in the designer.

OK, so what's wrong?

more ▼

asked Dec 12 '09 at 06:29 PM in Default

Rod gravatar image

Rod
801 46 50 52

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

If the query window was opened before the table was created, Intellisense will not automatically know about the new table. Press CTRL-SHIFT-R to refresh the local Intellisense cache.

more ▼

answered Dec 12 '09 at 07:49 PM

Tom Staab gravatar image

Tom Staab
5.8k 6 8 10

(comments are locked)
10|1200 characters needed characters left

Intellisense info gets populated and stored in a cache. It doesn't query the system every time you start typing. There's an Intellisense menu in the Edit menu (I think), which will also show you that the shortcut to refresh the cache is Ctrl+Shift+R. Bear in mind that other systems will use this same shortcut (like SnagIt), which is why you should be aware of the menu item for it.

more ▼

answered Dec 12 '09 at 08:53 PM

Rob Farley gravatar image

Rob Farley
5.7k 15 18 20

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1816
x123
x103
x5

asked: Dec 12 '09 at 06:29 PM

Seen: 5782 times

Last Updated: Dec 13 '09 at 12:32 PM