Apr 8, 2025 · This function returns the name of a specified database. Transact-SQL syntax conventions. Syntax DB_NAME ( [ database_id ] ) Arguments database_id. The identification number (ID) of the database whose name DB_NAME returns. If the call to DB_NAME omits database_id, or the database_id is 0, DB_NAME returns the name of the current database. …

With the MSSQL queries below, you can check the current database: SELECT DB_NAME() GO master. In addition, if you don't specify a database on sqlcmd, "master" database is used by default.

You can get the instance name of your current database as shown below: SELECT @@SERVICENAME -- SQLEXPRESS SELECT SERVERPROPERTY ('InstanceName') -- SQLEXPRESS

Oct 27, 2023 · To find database names in SQL Server using query, you have two ways: first, you can find the name of the database using the database ID, or you can use a function that shows the name of the currently connected database.

Jul 21, 2011 · select name from sys.sysdatabases where dbid=db_id() or. select DB_NAME(db_id())

Dec 11, 2024 · Finding database name in SQL servers is a daily task for an SQL developer. In this article, I will guide you through multiple ways to find a database name in SQL server with some real-time examples.

Jan 2, 2025 · The DB_NAME() function in SQL Server is a built-in function that retrieves the name of the current database or a specified database based on its database ID. This function is extremely useful when we need to confirm the database context or include the database name in our query results for clarity.

Oct 31, 2023 · In this SQL Server tutorial, you will learn to find database name in SQL Server Management Studio. You will understand how to find the name of the database through Object Explorer in SSMS. After that, you will learn through examples how to find the name of a database using a query in SSMS.

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 ...

Here, we will show you how to Get database names in the Server. You can also use sysdatabases to get the list of databases available in the Server. Or, use the sp_databases stored procedure to get a list of databases in the Sql Server. In this example, we will restrict the result.