List All Databases

Posted on July 2, 2010 by Derek Dieter
0
0

« List All Tables in a Database

List All Columns in Database or Server »

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

[cc lang=”sql”]
SELECT *
FROM sys.sysdatabases
[/cc]

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

Post a comment

Featured Articles

How to cache stored procedure results using a hash key There are a lot of different design patterns that lend themselves to creating
SQL Server Database Optimization Guide In the troubleshooting guide we went over the different physical bottlenecks that can
Yet Another Temp Tables Vs Table Variables Article The debate whether to use temp tables or table variables is an old
Using Union Instead of OR Sometimes slow queries can be rectified by changing the query around a bit.

Site Author

Thanks for visiting!

Resources