is it possible to re-order the intellisense options as they appear?

Question

Post reply

is it possible to re-order the intellisense options as they appear?

davidandrews13

SSCertifiable

Points: 6809
More actions
April 3, 2012 at 7:34 am

#254254

for example, i start typing in my code:
select
a.*
from
foo
and at the point that i'm typing in 'foo' the intellisense options show.
currently, it lists them like so:
footballTeamPlayer
footballTeam
football
i believe its ordering it by alphabetical order, ascending. what it means is that if i want to search the Football table, i have to constantly navigate to it with the keyboards arrow-keys. is it possible to list them in descending order?
football
footballTeam
FootballTeamPlayer
that way, if i only want table Football, its the first in the list (when i finish typing the table name 'Football'. and if i want table FootballTeam, thats also first in the list if i type 'footballT'.
cheers

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398886 More actions · Answer 1

There must be something else going on. You should be seeing Football first. See this example from AdventureWorks

You can see the SalesPerson and then the SalesPersonQuotaHistory. Yours should be going the same order.

But no, you can't change the order of the sort. Same thing with SQL Prompt from Red Gate. The order is fixed on alphabetical.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

davidandrews13 SSCertifiable Points: 6809 More actions · Answer 2

ok. thats weird.

my example was totally made up to illustrate my point. Maybe, in making it up, i inadvertently made it less clear what was going on.

Here are my table names in the order they appear (i've replaced the actual name with the word 'football' but the rest of the name is correct):

footballStates

footballUnits

footballValidation

footballValidationStates

football_suspend

footballs

footballs_MLFlags

thanks for your response though 😎

CapnHector SSCoach Points: 16143 More actions · Answer 3

davidandrews13 (4/4/2012)
ok. thats weird.
my example was totally made up to illustrate my point. Maybe, in making it up, i inadvertently made it less clear what was going on.
Here are my table names in the order they appear (i've replaced the actual name with the word 'football' but the rest of the name is correct):
footballStates
footballUnits
footballValidation
footballValidationStates
football_suspend
footballs
footballs_MLFlags
thanks for your response though 😎

its not football its footballS there is an s at the end of football so its sorted alphabeticly just as it should be.

For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]

Sean Lange SSC Guru Points: 286590 More actions · Answer 4

capn.hector (4/4/2012)
davidandrews13 (4/4/2012)
ok. thats weird.
my example was totally made up to illustrate my point. Maybe, in making it up, i inadvertently made it less clear what was going on.
Here are my table names in the order they appear (i've replaced the actual name with the word 'football' but the rest of the name is correct):
footballStates
footballUnits
footballValidation
footballValidationStates
football_suspend
footballs
footballs_MLFlags
thanks for your response though 😎
its not football its footballS there is an s at the end of football so its sorted alphabeticly just as it should be.

Actually it is not really sort alphabetically. footballStates and footballs are very far apart.

It appears that at least the native intellisense does not sort alphabetically and instead sorts by ASCII value. This list is sorted perfectly by ASCII values.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

davidandrews13 SSCertifiable Points: 6809 More actions · Answer 5

i see. i guess i'll just have to put up with it 🙂 thanks anway!

i was hoping to get it sorted like so: