Post reply

Change Default Schema for a Session (not a user)

  • September 16, 2009 at 3:34 pm

    #135710

    I would like to change the default schema programatically for the session the code is running in, is there a way to do this similar to the below?

    Alter Session set default schema = 'dbo'

    Select * from Table1 --This query pulls data from Table1 in the dbo schema

    Alter Session set default schema = 'client'

    Select * from Table1 --This query pulls data from Table1 in the client schema

    Thanks,

    Carleton

  • September 17, 2009 at 1:18 am

    #1054818

    As far as I know there is no "default schema" for a session. But you can set a default schema for your user in every database it has access to.

  • September 17, 2009 at 5:38 pm

    #1055309

    I did realize that I can assign a default schema to a user, but what I was searching for was a statement that would allow me to change the default just for the session.

    I just found an enhancement request on Mircosoft's site. Someone was asking that the USE statement be expanded to include changing the context of the default schema. Looks like I'll have to wait on this.

    Thanks,

    Carleton

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

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