 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
Reserved Keyword table names interferes with intellisense |
|
v5.0.97 Pro
SQL 2008
Assuming a table named Subscription. The following shows a table, but not column names.
Select Su
Select s.
From dbo.[Subscription] s
Pressing F5 (refresh) causes the column names to show up. This is an old table thats been around a while.
If this was already submitted, sorry, didn't see it.
|
|
Fri Jun 04, 2010 11:05 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Would you please provide DDL for this table which I can use to recreate this table locally?
|
|
Fri Jun 04, 2010 11:24 am |
|
 |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
|
|
I tried to reproduce it after closing and reopening SSMS, but can't. I've seen it a few times where the intellisense just doesn't want to give you the columns for a table, but hitting refresh clears the issue.
|
|
Fri Jun 04, 2010 2:41 pm |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|