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、如何sql语句查询出数据库每个表的几条数据
select schema_name(t.schema_id) as [Schema], t.name as [表名],i.rows as [总行数]
from sys.tables as t, sysindexes as i
where t.object_id = i.id and i.indid <=1
5、查询库里哪个表里有这个“字段名”
SELECT [name] FROM [库名].[dbo].sysobjects WHERE id IN (SELECT id FROM [库名].[dbo].syscolumns WHERE name = ‘字段名’)