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

Synonyms?

The product does not appear to support synonyms:
create synonym r for sales.salesorderdetail

...
SELECT * FROM

... No "r" in the list.
amachanic
0

Comments

3 comments

Sort by
  • Lionel
    Good spot! I didn't realise that people actually used these! I have added synonym support to our list of sugested features.

    Lionel
    Lionel
    0
  • drsql
    I know that several people I work with use them extensively for ETL because we have some databases that a misguided person installing a certain product in dev, qa, preprod, etc thought it would be good to rename the database for the environment it is in, so we use them to vary the synonym rather than the code.

    So synonyms would be definitely used.
    drsql
    0
  • Lionel
    That sounds like a nightmare. Definatly sounds like a good use for synonyms though.

    Lionel
    Lionel
    0

Add comment

Please sign in to leave a comment.