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 CustomerTraining schema under AdventureWorks database...
Why its not showing ? Can someone help......
