Autocomplete column names for tables don't match

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Other SQL Server 2008 Topics

Autocomplete column names for tables don't match

Author

Topic

ravl13
Starting Member

38 Posts

Posted - 2011-09-28 : 12:02:28

Greetings,

When I type a query on a table such as


SELECT *
FROM CCNcontacts
WHERE LastGiftDate > 'jan 1, 2001' and largestgift > 200

When I start typing 'largest', the autocomplete menuthing suggests the column 'largestgiftamount', and 'largestgift' doesn't even show up as an option. I believe the column in the CCNcontacts table was called 'largestgiftamount' at some point, but it has been changed to simply 'largestgift' for the past couple of weeks. How can I update the autocomplete menuthing to suggest the current correct column name?

Thanks!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-28 : 12:05:55

no need to do that. Even if the change is already done it will not sometimes take changed column info if you not using a new connection.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources