Skip to content
«
»
 

List All Databases

Posted by 
on  July 2 2010

To list all databases in a SQL Server instance, run the following:

SELECT *
FROM sys.sysdatabases

This also outputs metadata about each database including createdate, compatibility level, and the MDF filename.



Popular search terms:
Filed under DBA, TSQL
Comment (RSS)  |  Trackback  |  Permalink

post a comment OR Post Your Question on our ASK! Community!

«
»