Skip to content
← SQL Prompt

How can we improve SQL Prompt?

SQL Prompt: Expand wildcards

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Enhance Press tab to expand

Right now, if I have

Select * From TableA As ta
Inner Join TableB as tb On ta.Key = tb.Key

and I "Press TAB to expand wildcard" only the fields that are in common get qualified with the table aliases. I would like to see an option of ALWAYS having the table alias added even if there is only one table.

5 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Jim shared this idea  ·   ·  Report…  ·  Admin →

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • AdminAaron Law (Admin, Redgate) commented  ·   ·  Report

    Hi Kresten,
    We've just split this option into two in our 6.4 beta so there's now:
    - Qualify column names with aliases (on by default)
    - Qualify column names with table name (off by default)
    Hopefully this makes things clearer and gives more control as it seems many people like aliases used in qualifications but not table names.

    You can download the beta from: http://www.red-gate.com/messageboard/viewtopic.php?t=20800

  • Kresten Birkegaard Gregersen commented  ·   ·  Report

    Wow there it was... I would never have guessed it from the name "Qualify column names with table name" - perhaps there could be a hint under the Aliases section about it...
    Some thing like to always include alias use this option "Qualification -> Qualify column names with table name"

  • Jim commented  ·   ·  Report

    Hi Paul,

    No, I had not tried it because I did not want to qualify my columns with the *Table names* just the alias.

    But, I now see that it will use the alias instead, if there is one.

    Thanks!

  • AdminPaul Stephenson (Admin, Redgate) commented  ·   ·  Report

    Hi Jim,

    Have you tried the option "Qualification > Qualify column names with table name"? If I understand what you're saying, this should be what you want.