select * from sysdatabases order by name
- 查询数据库中所有表
select * from sysobjects where xtype='U';
xtype='U' 表示所有用户表
select * from sysobjects where xtype='S';
xtype='S' 表示所有系统表
- 查询指定表所有字段名
select name from syscolumns where id=Object_Id('Bod_Tag)';
- 用户所属数据库角色
use yourdb
go
select DbRole = g.name, MemberName = u.name, MemberSID = u.sid
from sys.database_principals u, sys.database_principals g, sys.database_role_members m
where g.principal_id = m.role_principal_id
and u.principal_id = m.member_principal_id
order by 1, 2
go
- 登陆帐户所属服务器角色
use master
go
select SrvRole = g.name, MemberName = u.name, MemberSID = u.sid
from sys.server_principals u, sys.server_principals g, sys.server_role_members m
where g.principal_id = m.role_principal_id
and u.principal_id = m.member_principal_id
order by 1, 2
go
- 查询所有用户表
select name from Bod..sysobjects where xtype='u' order by name
