Conversations On tech, literature, art and business

SQL Intellisense Refresh

This one is pretty tech specific. Ignore if you don't know or care what SQL, SSMS, or Intellisense are.

When working with Microsoft SQL Server Management Studio, you will often find yourself making changes to table structures in one window and writing queries in another. Very useful ability but schema changes are not automatically reflected by Intellisense in all open query windows.

Quick example:

You create table myTable with 2 columns:

CREATE TABLE [dbo].[myTable](
[Zone] [int] NULL,
[Item] [nchar](6) NULL
) ON [PRIMARY]

GO

And then in another window you have this simple select:

select zone, item from myTable

Then you decide to add a new column to myTable, [iName] nchar(8) NULL

Not a big deal in this context. YOU know the column is there. But in more complex queries Intellisense will do all sorts of nasty things to you as you bang out your queries. Like autocompleting your table names or columns with crazy replacements.

How to fix this without closing the query window and opening a new one? Easy!

CTRL + SHIFT + R

OR

Edit -> Intellisense -> Refresh

Handy shortcut I thought. Thanks to @scottstonehouse for bringing this problem to mind.