Professional Web Applications Themes

Similar to Synonyms in Oracle - Microsoft SQL / MS SQL Server

Hello, In oracle we can define a synonym for schema.tableName Can this be done in SQL Server? If yes, how? Thanks Anand...

  1. #1

    Default Similar to Synonyms in Oracle

    Hello,

    In oracle we can define a synonym for schema.tableName
    Can this be done in SQL Server? If yes, how?

    Thanks
    Anand
    Anand Guest

  2. #2

    Default Re: Similar to Synonyms in Oracle

    There is no such think as a synonym. The closest that I can think of is, to
    have views created over your tables with appropriate names.
    --
    HTH,
    SriSamp
    Please reply to the whole group only!
    http://www32.brinkster.com/srisamp

    "Anand" <org> wrote in message
    news:0bd501c351c2$391a5c40$gbl... 


    SriSamp Guest

  3. #3

    Default Re: Similar to Synonyms in Oracle

    You could create a view.

    "Anand" <org> wrote in message
    news:0bd501c351c2$391a5c40$gbl... 


    Anthony Guest

Similar Threads

  1. Replies: 3
    Last Post: November 15th, 07:54 PM
  2. Replies: 2
    Last Post: April 11th, 03:47 PM
  3. Synonyms to an SE database
    By Andy in forum Informix
    Replies: 11
    Last Post: December 3rd, 05:12 PM
  4. #13053 [Com]: oci8 error, this kill oracle-prosseces in the oracle-instance.
    By gid at gifpaste dot net in forum PHP Development
    Replies: 0
    Last Post: November 20th, 06:51 PM
  5. Difference between oracle Synonyms and Views.
    By Prem in forum Oracle Server
    Replies: 12
    Last Post: October 29th, 06:12 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139