LKBEN11633: How to get a list of all databases on SQL Server
Symptom
You need to enumerate all databases on your SQL Server
Cause
Used for documentation.
Solution
To get a list of all databases on your Microsoft SQL Server you have several options.
The first one is to use the GUI. You logon to Microsoft SQL Server Management Studio and expand the databases. This is nice but sometimes it's easier to use some TSQL to get the same result.
The second possibility is to use a stored procedure sp_databases.
sp_databases
This will give you a list of all the databases, their size and remark.
A third possibility is to query the master databases like this:
SELECT name FROM master.dbo.sysdatabases
This will give you the names of the databases.
Have fun.
Disclaimer:
The information provided in this document is intended for your information only. Lubby makes no claims to the validity of this information. Use of this information is at own risk!About the Author
Author: - Keskon GmbH & Co. KG
Wim Peeters is electronics engineer with an additional master in IT and over 30 years of experience, including time spent in support, development, consulting, training and database administration. Wim has worked with SQL Server since version 6.5. He has developed in C/C++, Java and C# on Windows and Linux. He writes knowledge base articles to solve IT problems and publishes them on the Lubby Knowledge Platform.
Latest update: 08.01.2023