How can we help you today? How can we help you today?

CTRL+SPACE after JOIN gives me column names

If I invoke the completion canidate list immediately after the JOIN keyword, I am presented with the "All common objects" list. I would rather be presented with the "Tables" list.

Query Analyzer
DaveTheWave
0

Comments

5 comments

  • Lionel
    This is actually how it is suposed to work. The reason it doesn't go straight to the tables list is because there is both a views and a tables list and both are sensible choices in this situation. I guess the All common objects is maybe a confusing name. The idea behine this list is it should list the relevent objects for where you are in the query. In this situation it should give you a list of views and tables. If it isn't then this is a bug. Does this sound sensible (We did consider opening on the tables list like you sugested but change our minds due to the reasons above) ? Also would this have made sense if that list had got a better name ?
    Lionel
    0
  • amachanic
    It might make more sense if you order the candidates differently. Tables, then views, then TVFs, would probably be a good order.
    amachanic
    0
  • Lionel
    This is what we are aiming for. It is sounds like we should find a better name for the all candidates list than the curent one though.

    Lionel
    Lionel
    0
  • DaveTheWave
    The list that I'm presented with includes columns and not just tables or views.
    DaveTheWave
    0
  • Tilman
    Hi,

    We've added the issue to our list and it will be fixed for the final release.

    Regards,

    Tilman
    Tilman
    0

Add comment

Please sign in to leave a comment.