Changing Schema Context 1

[rebelknight]

You can assign a default schema to a user and you can define a schema owner.

Can you also change the schema context of a connection?

For example you can change a database in query session by typing USE AnotherDatabase. Is there a way you can select USE AnotherSchema within a database?

 

[mrdenny]

Nope. There is no way to change the default schema for a single session.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog