T-SQL Tutorial

How to get SQL Server database name

Determining the name of the current SQL Server database can be essential for various tasks, including executing queries, managing database objects, and troubleshooting issues. There are two primary methods for retrieving the database name in SQL Server: using the DB_NAME() function or employing SQL Server Management Studio (SSMS).

Using the DB_NAME() Function

The DB_NAME() function is a built-in Transact-SQL (T-SQL) function that returns the name of the current database. It takes no parameters and simply returns the current database name. Here's an example of how to use the DB_NAME() function to retrieve the database name:

SELECT DB_NAME() AS [Current Database];

This query will return a single result row, with the column name Current Database containing the name of the current database.

Using SQL Server Management Studio (SSMS)

SQL Server Management Studio (SSMS) is a graphical user interface (GUI) tool for managing SQL Server instances and databases. It provides a straightforward way to view the current database name. Follow these steps to obtain the database name using SSMS:

1. Launch SQL Server Management Studio and connect to the SQL Server instance you want to query.
2. In the Object Explorer pane, expand the server instance and then expand the Databases node.
3. Right-click the database whose name you want to retrieve and select Properties.
4. In the Properties window, locate the General tab. The Database Name field displays the name of the selected database.

Both methods effectively provide the current database name within SQL Server. The choice between them depends on your preference and the context of your work. The DB_NAME() function is more suitable for incorporating into T-SQL queries, while SSMS offers a visual interface for retrieving and verifying database information.