Get list of databases from SQL Server

Posted By: sef

How can I get the list of available databases on a SQL Server instance? I’m planning to make a list of them in a combo box in VB.NET.

Solution

Execute:

SELECT name FROM master.sys.databases

This the preferred approach now, rather than dbo.sysdatabases, which has been deprecated for some time.

---

Execute this query:

SELECT name FROM master.dbo.sysdatabases

or if you prefer

EXEC sp_databases

Answered By: Ben Hoffstein

Disclaimer: This content is shared under creative common license cc-by-sa 3.0. It is generated from StackExchange Website Network.