SQL Server Performance

What is the synonym equivalent object

Discussion in 'General Developer Questions' started by sqldev, Nov 24, 2005.

  1. sqldev New Member

    Hi,

    1) Do we have anything which is equivalent to synonym in oracle? If it is not available, how do we simulate it? please provide me the details, thank you.

    2) When we use "Select * into NewTable from OldTable" command, it just creates a new table without the constraints which the old table has got. I understand, there could be a collision in the constraint names, but is it possible to create it without some other default name, just in the way sql server does when constraints are created with out providing any name. If it is possible, we can rename them later on. Just a thought, not sure whether it is sensible, please give me your suggestions, thank you.

    Regards
    Deva
    sqldev, Nov 24, 2005
    #2

  2. Madhivanan Moderator

    I think you need VIEW

    Create VIEW myView as
    Select * from oldTable

    Madhivanan

    Failing to plan is Planning to fail
    Madhivanan, Nov 24, 2005
    #2

  3. FrankKalis Moderator

    FrankKalis, Nov 24, 2005
    #2

  4. satya Moderator

    Check SQL 2005 for more information on Synonyms.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Nov 25, 2005
    #2

  5. Madhivanan Moderator

    quote:Originally posted by satya

    Check SQL 2005 for more information on Synonyms.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    So in SQL Server 2005, views are replaced as Synonyms?

    Madhivanan

    Failing to plan is Planning to fail
    Madhivanan, Nov 25, 2005
    #2

Share This Page