SQL Management Studio won't recognize a table exists after scripted create

Question

So if I create a new table in the query editor in SQL Management Studio after hitting refresh on the DB I can see and work with that table. However if I want to run another query referencign that table from withen the query editor it doesn't reconize that table exists. I've tried hitting refresh at the DB level, and the table level but it makes no difference. However if I quit the management studio then reopen it shows up fine.

USE [DataBaseName]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[States](
    [StateAbbreviation] [nchar](2) NOT NULL,
    [StateFullName] [nchar](30) NULL,
GO

So I run that and then run this.

INSERT INTO States
SELECT *
FROM ExistingStatesTable

This fails saying that States doesn't exist. Also States doesn't show up in the intelisense. What should I do to

score 205 · Accepted Answer · answered Feb 04 '10 at 16:13

205

Press Ctrl-Shift-R to refresh the intellisense.

answered Feb 04 '10 at 16:13

6

almost 8 years later, and confirmed still works on SQL Server 2017 – Raymond Nov 09 '17 at 15:54

Roberto · Answer 2 · 2011-01-20T01:05:00.350

16

If you prefer, you can use the menu to refresh the cache:

Edit>Intellisense>Refresh Local Cache

The good thing using the menu, is that you will learn some new Intellisense hot-keys...

SQL Server Management Studio Intellisense doesn’t work after schema changes

edited Jan 20 '11 at 01:05

answered Jan 17 '11 at 22:12

Roberto

645
1
8
16

score 6 · Answer 3 · edited May 18 '22 at 20:17

6

You probably did what I always do. I often create a table while connected to the wrong database, or the default database. For me, the default database is 'master' so I have a lot of garbage in my master DB :)

edited May 18 '22 at 20:17

answered Feb 04 '10 at 16:12

Randy Minder

47,200
49
204
358

or the wrong server, I've done that a tiem or two as well, created the database on one server ran the query on another. – HLGEM Feb 04 '10 at 16:14
No I can refresh the object browser on the left and it shows the table in the right DB – jamone Feb 04 '10 at 16:16

score 0 · Answer 4 · answered Feb 04 '10 at 16:40

0

I right-click on the Tables and Select Refresh from the context-sensitive menu (Ctrl-R works too)

answered Feb 04 '10 at 16:40

Terry

21
1
4

"Refresh" from the menu doesn't work for me regardless where I right-click in the object tree (v18.9.2). – FloverOwe Feb 02 '23 at 00:50

SQL Management Studio won't recognize a table exists after scripted create

4 Answers4

Linked