Skip to content
← SQL Complete

How can we improve SQL Complete?

SQL Complete

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Custom Alias Map - Tell SQL Complete to always use a specific alias for specific table

I have a table (ObjectReference) and Sql Complete maps it to or1. I understand why it adds the 1 to avoid using the "or" keyword, but it would be nice to set up Sql Complete to use a more friendly keyword.

One solution for this would be to allow me to map table names to alliases. Then, any time ObjectRerence is used, it would get oRef (or whatever) from the map.

44 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Kevin Croke 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
  • Kevin Croke commented  ·   ·  Report

    I'm excited this made it on to the backlog. Thanks!

  • Anonymous commented  ·   ·  Report

    Agree, this would be helpful for the core group of tables that i work with 90% of the time that i'm used to a certain alias with. The other tables could be auto aliased.

  • Jeremy commented  ·   ·  Report

    Yes - this would be extremely useful for us as well - we have many aliases which do not match the logic provided for aliases by SQL Complete, and we have to change them each time we reference a table that historically has a different alias.

    Please add this feature!

    Thanks.

  • Esp commented  ·   ·  Report

    This feature is also available in Red-Gate SQLPrompt, it's very useful to assign more meaningful aliases to tables you use all the time.

    For example, setup "fis" for factinternetsales, "fsr" for factsurveyresponse, and when it's used multiple times it'll be fis, fis1, fis2, fsr, fsr1, fsr2...

    It makes the queries much more understandable than f1, f2, f3, ...

  • Anonymous commented  ·   ·  Report

    This feature is available Apex SQL Complete which made that product a strong contender for me. If this were to be included in dbForge SQLComplete that would make the tool an outright winner.