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: 7951
|
|
|
|
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 |
|
 |
|