Dynamically change my schema

Posted by Kirk on Stack Overflow See other posts from Stack Overflow or by Kirk
Published on 2010-04-17T00:34:49Z Indexed on 2010/04/17 1:13 UTC
Read the original article Hit count: 321

Filed under:
|
|

I am wondering if there is a way to change the schema that I am working in while inside Management Studio. For instance I may have a default schema of dbo. But there are times I may want to query objects in say the accounting schema. It would be nice if I could issue a command and make it so I no longer must include the accounting before tables and views. But the next time I go in, I will be back to default of dbo.

© Stack Overflow or respective owner

Related posts about tsql

Related posts about mssql2008