how to change user/schema in SQL query on MSSQL 200*

Thanks to my friend Oleksy who is the champion in googling :)

Here is how to change user/schema in SQL query on MSSQL 200*
For instance I connected with "sa" and my schema is "dbo". I want to query tables from schema "teamworks", but don't want to specify "teamworks" prefix.

SETUSER 'teamworks'

SELECT
MY_TABLE.GROUP_ID
FROM
MY_TABLE

SETUSER