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