1.获取所有用户名:
SELECT name FROM Sysuserswherestatus='2'and islogin='1'
islogin='1'表示帐户
islogin='0'表示角色
status='2'表示用户帐户
status='0'表示糸统帐户
2.获取所有表名
SELECT Name FROM DatabaseName..SysObjects Where XType='U'ORDER BY Name
XType='U':表示所有用户表;
XType='S':表示所有系统表;
3.获取所有字段名:
SELECT Name FROM SysColumns WHERE id=Object_Id('TableName')
4.获取主键字段
SELECT name FROM SysColumns WHERE id=Object_Id('表名') and colidin(selectkeyno from sysindexkeyswhereid=Object_Id('表名'))
5.同时获取主键名与表名
SELECT b.name as keyName,a.Name as Tablename FROM SysObjects a,SysColumns b Where a.XType='U' and b.id=Object_Id(a.Name) and
b.colid in (select keyno from sysindexkeys where id=Object_Id(a.Name))
本文来自:http://hi.baidu.com/hanrenjun/item/dc5bc9770397fe2b5c1789a4