lyfz_repos/经典版源码/document/数据库维护脚本/sql 语句 取数据库服务器上所有数据库的名字.sql

--取得所有数据库名 包括系统数据库 
select name from master.dbo.sysdatabases 
--取得所有非系统数据库名 
select name from master.dbo.sysdatabases where dbid>6 order by name 
--取所有信息,包括数据库文件地址 
select * from master.dbo.sysdatabases where dbid>6 order by name 

select count(*) from master.dbo.sysdatabases where name = '2009'
select count(*) from master.dbo.sysdatabases where name = '2010'
select count(*) from master.dbo.sysdatabases where name = '2011'
select count(*) from master.dbo.sysdatabases where name = '2012'
select count(*) from master.dbo.sysdatabases where name = '2013'
select count(*) from master.dbo.sysdatabases where name = '2014'
select count(*) from master.dbo.sysdatabases where name = '2015'

select * from master.dbo.sysdatabases where name in('2009','2010','2011','2012','2013','2014','db') order by name

select * from master.dbo.sysdatabases where filename like '%\数据\%'