SQL Server query to find all current database names

Question

I need a SQL query to find the names of existing databases.

Answer 1

select name from master..sysdatabases

Answer 2

This forum suggests also:

SELECT CATALOG_NAME AS DataBaseName FROM INFORMATION_SCHEMA.SCHEMATA

Answer 3

select name from sys.databases

You'll only see the databases you have permission to see.

Answer 4

Another to add to the mix:

EXEC sp_databases

Answer 5

I don't recommend this method... but if you want to go wacky and strange:

EXEC sp_MSForEachDB 'SELECT ''?'' AS DatabaseName'

or

EXEC sp_MSForEachDB 'Print ''?'''