SQL Server 2008 Intellisense问题 [英] SQL Server 2008 Intellisense problem

问题描述

可能重复:
失去了智能感

Possible Duplicate:
Lost the IntelliSense

我已经在Adventure Server数据库中的SQL Server 2008中创建了名为CustomerTraining的架构.然后创建一个名为Customer的表，如下所示:

I have created schema in SQL Server 2008 called CustomerTraining in the AdventureWorks database. Then created a table called Customer like this:

create schema CustomerTraining

create table CustomerTraining.Customer
(
CustomerID int not null,
CustomerName nvarchar(25) not null,
TerritoryID int  null,
AccountNumber nvarchar(20) not null,
CustomerType nvarchar(20) not null,
CustomerAddress nvarchar(20) not null,
CustomerPhone nvarchar(20)  null,
CustomerStateCode nchar(2) null
)

然后我开始插入一些记录:

then I began to insert some record :

insert into AdventureWorks.CustomerTraining.Customer
values(1,'Prateek Singh','1','A4B8934561','Internal','Anna Nagar','7418773929','TN')

对我来说一切正常，但在智能感知中，它没有显示AdventureWorks数据库下的CustomerTraining模式...

It all works fine for me but in the intellisense its not showing CustomerTraining schema under AdventureWorks database...

为什么它不显示?有人可以帮忙吗……

Why its not showing ? Can someone help......

推荐答案

按 Ctrl + Shift + R 到或者如果这不起作用(某些SSMS插件劫持了这种组合)，则可以通过菜单选项Edit -> IntelliSense -> Refresh Local Cache

Or if that doesn't work (some SSMS addins hijack this combination) do it through the menu options Edit -> IntelliSense -> Refresh Local Cache

这篇关于SQL Server 2008 Intellisense问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！