1.获取所有数据库名:
Select Name FROM Master..SysDatabases ORDER BY Name
2.获取所有表名:
Select Name FROM SysObjects Where XType='U' ORDER BY Name
XType='U':表示所有用户表;
XType='S':表示所有系统表;
3.获取所有字段名:
Select Name FROM SysColumns Where id=Object_Id('TableName')
4.获取指定数据库下的用户表
use "vgm"
Select Name FROM SysObjects Where XType='U' ORDER BY Name
5.获取所有表的所有数据
select id,object_name(id) as tableName,indid,rows,rowcnt
from sys.sysindexes a
order by rows desc
6.获取指定表的数据
use tsp2
select id,object_name(id) as tableName,indid,rows,rowcnt
from sys.sysindexes a
order by rows desc
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26273052/viewspace-1058726/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26273052/viewspace-1058726/