Post reply

!ActiveSchema!

  • August 29, 2007 at 6:40 am

    #93550

    HI All,

    I recently came across some code that looked like this.

     

    IF

    EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[!ActiveSchema!].[Marriage]'))

     

    I can't find any documentation on [!ActiveSchema!]

    I can only guess and assume that the object_id  Function turns that "special" value intot he current schema being used!

    Please could someone let me know if this is true or what actually happens here?

    Thanks

    Chris

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life

  • August 29, 2007 at 6:51 am

    #730065

    Hi All,

    Sorry about this.

    It seems that with some further coding and testing that this [!ActiveSchema!] is actually jsut something that needs to be replaced with a real schema word e.g. [dbo]

     

    Thanks

    Chris

     

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life

Viewing 2 posts - 1 through 1 (of 1 total)

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