Get Database Names from SQL Server

In this article, we will show you, How to write a SQL Query to Get Database Names from SQL Server with example. This is one of the common Interview Question that you might face in the interviews.

Below screenshot will show you the list of databases that are available in our Sql Server.

Get Database Names from SQL Server Example 1

In this example we will show you, How to Get SQL Server database names

-- Query to get SQL Server Database Names
USE master
GO
SELECT name FROM sys.databases

OUTPUT

You can also use sysdatabases to get the result.

-- Query to get SQL Server Database Names
USE master
GO
SELECT name FROM sysdatabases

OUTPUT

Or, use sp_databases stored procedure

-- Query to get SQL Server Database Names
USE master
GO
EXEC sp_databases

OUTPUT

Get Database Names from SQL Server Example 2

In this example, we will restrict the result to display the databases without system databases.

If you know the database id then use the following query

-- Query to get SQL Server Database Names
USE master
GO
SELECT database_id, name FROM sys.databases
WHERE database_id > 4

OUTPUT

Or, try NOT IN operator

-- Query to get SQL Database Names
USE master
GO
SELECT database_id, name FROM sys.databases
WHERE name NOT IN ('master', 'model', 'msdb', 'tempdb')

OUTPUT