SQL Server query to find all current database names

Question

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

User · Answer

Here is a query for showing all databases in one Sql engine  Select   from Sys Databases

User · Answer

For people where  sys databases  does not work   You can use this aswell   SELECT DISTINCT TABLE SCHEMA from INFORMATION SCHEMA COLUMNS

User · Answer

SELECT datname FROM pg database WHERE datistemplate   false   for postgres

User · Answer

You can also use these ways   EXEC sp helpdb   and   SELECT name FROM sys sysdatabases   Recommended Read   Don t forget to have a look at sysdatabases VS sys sysdatabases  A similar thread

User · Answer

This forum suggests also    SELECT CATALOG NAME AS DataBaseName FROM INFORMATION SCHEMA SCHEMATA

User · Answer

SELECT name   FROM sys databases      You ll only see the databases you have permission to see

User · Answer

Another to add to the mix   EXEC sp databases

User · Answer

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

[sql-server] SQL Server query to find all current database names

Examples related to sql-server