Post reply

synonym in SQL Server

  • September 20, 2005 at 6:23 pm

    #89991

    Hi all,

               I have a big question can I make a synonym in sql server as like in Oracle.

              "create synonym emp for employee" like this.

    Help me its urgent.

                                                     Thanks in advance.

                                                     Manutosh

  • September 20, 2005 at 7:44 pm

    #591560

    SQL Server didn't have synonym object like in oracle.

  • September 23, 2005 at 11:08 am

    #592669

    As Deni Kusdeni mentioned, the current production versions of SQL Server does not support synonyms.  However, SQL 2005 will have the ability to assign synonyms to objects. 

    You probably can't wait that long though ...

    Have a good day,

    Norene Malaney

  • September 23, 2005 at 12:52 pm

    #592726

    Curiosity question. Why would you want to create a synonym name for employee as emp ..... why cant you just use the three part name ?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply