Competition: What’s your favorite Redgate tool? Enter now.

auto insert - user defined aliases are ignored

austrianfoodispukeaustrianfoodispuke Posts: 100
edited June 10, 2008 4:07PM in SQL Prompt Previous Versions
I have

name alias
issue iss

set up in the options dialog.

When I type "issue" it puts "i" at the end instead of iss (when selecting with autocomplete)

If I don't select the table using autocomplete then it doesn't put anything (by design?)

Comments

  • Hello,

    User-defined aliases are case sensitive, i.e. if you table name is recorded as Name in the database, then typing name in the user-defined alias will not get the user defined alias to work for that table 'Name' in your queries.

    And yep, alias assignment works only on using auto-completion. I presume it was part of the design but I should admit that I am not entirely sure on that end!

    Thanks,
    Tanya
Sign In or Register to comment.