SELECT all Databases

This statement lists all databases in the SQL Server:

SELECT 
	name 
FROM 
	master.sys.databases 
ORDER BY 
	name;

Or you can execute the Stored Procedure sp_databases:

EXEC sp_databases;