Home > Sql Server, Tips and Tricks > Sql 2008 Intellisense

Sql 2008 Intellisense

February 2nd, 2010

I’ve been using Sql 2008 fairly regularly lately with a couple of projects.  I realize there are far bigger features with this release, but Intellisense is great!  I love my Intellisense with Visual Studio, and now having it with Sql Server is nice.

I’m in the process of creating a new database, and therefore adding several tables and populating them with data.  It was frustrating to add a table, but it not appear with Intellisense when writing an insert statement.  Those red squiggly lines always jump out, and I think I’ve misspelled the table name yet the statement is correct.

The fix is simple, all you have to do is update the Local Cache one of 2 ways:

  • Edit -> Intellisense -> Refresh Local Cache
  • Control-Shift-R

Personally I am a fan of the second method, the more I can do without my mouse the faster I can go.  But either works fine.  Now, back to my database!

  1. alison
    April 15th, 2011 at 13:43 | #1

    Hello. I am jeremy’s daughter, Alison. tolsdorf.net is a great family website and my daddy made it.

  2. Alison
    April 17th, 2011 at 19:00 | #2

    Computerz rock!!!!!!!!

  1. No trackbacks yet.
Comments are closed.