SQL 2008中如何查看用户有哪下架构，用代码查的，是在那个表中

                select a.uid,a.name as login_user_name,b.name as schemas_name                  from sys.sysusers a  join sys.schemas b on a.uid =b.principal_id                where a.issqluser=1 and islogin =1 and gid =0 and a.name='登录用户名'