Post reply

Can my table with two names in sql-server

  • March 9, 2004 at 7:31 am

    #163157

    Can i store my table with original and alias name,is it possible in sql-server?

    Thanks

  • March 9, 2004 at 7:39 am

    #497967

    Do you want a copy of your table?

    If not, you can always give an alias when querying the data of the table.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • March 9, 2004 at 7:54 am

    #497971

    If you're thinking of something like a synonym in Oracle, no.  Synonyms will be provided in Yukon, if you can wait that long

    In addition to Frank's idea, you could create a view of the entire table with a different name.

  • March 9, 2004 at 10:13 am

    #498008

    What does this do that a view doesn't do?

  • March 9, 2004 at 10:29 am

    #498014

    I'm assuming Steve that you're replying to me and mentioning a synonym. If you weren't, I apologize for the post

    Synonyms (in the Oracle sense) can be used for tables, views, stored procedures, etc. Just about anything. You can also set up synonyms for remote databases, essentially masking their real location. 

    In this particular case, a view would work as synonym in my opinion.  I'm not advocating their usage, I just got the sense that this is what the original question was implying

  • March 9, 2004 at 10:55 am

    #498023

    Steve,

    Synonyms in Oracle allow you to 'mask' your object names. Most of us use distinct naming conventions for objects, such as tblAddressBook.

    Users only see the synonym and not the 'real' name of the object, so it's harder to figure out what other objects might be in the database. And since it's an alias, it's performance is the same as using the 'real' name.

    -SQLBill

Viewing 6 posts - 1 through 5 (of 5 total)

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