开发者

SQL Server 2008 Intellisense problem [duplicate]

开发者 https://www.devze.com 2023-03-31 09:04 出处:网络
This question already has answers here: Closed 11 years ago. Possible Duplicate: Lost the IntelliSense I have created schema in SQL Server 2008 called CustomerTraining in the AdventureWork
This question already has answers here: Closed 11 years ago.

Possible Duplicate:

Lost the IntelliSense

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')

It all works fine for me but in the intellisense its not showing CustomerT开发者_运维百科raining schema under AdventureWorks database...

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


Press Ctrl+Shift+R to refresh the intellisense 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 problem [duplicate]


Ctrl+shift+R to refresh the cache?

0

精彩评论

暂无评论...
验证码 换一张
取 消