What are the challenges you face when working across database platforms? Take the survey
Options

Can't get alias working

sgray128sgray128 Posts: 7
edited August 20, 2007 8:12AM in SQL Prompt Previous Versions
Sirs:
I'm a new user, I'm trying to understand the alias functionality.

In Options > Auto Insert > Aliases I have added 'myTable' as an alias, with 'my' as the alias.

When I type 'select * from myTable', is the alias supposed to be added automatically?

If so, mine is not working. If not, how do I use the alias functionality?

Thanks!

Comments

  • Options
    Hi Steve,

    If you manually enter myTable rather than selecting it from the suggestion popup, then you will have to make sure that the cursor is at the end of myTable without any space and then press Ctrl+space keys. this will then fill in "my" for you.
    Technical Support Engineer
    Red Gate Software Ltd
Sign In or Register to comment.