Getting Current Database Name and ID using SQL Server

Getting Current Database Name and ID using SQL Server

In this blog, we see how to get ID and Name of current Database using SQL Server

SQL Snippet:

 

--To get the current database name

SELECT DB_NAME() AS [Database NAME];

 

--To get current database id

SELECT DB_ID() AS [Database ID];

OUTPUT:

 

Database NAME

------------------

Northwind

 

(1 row(s) affected)

 

Database ID

-----------

26

 

(1 row(s) affected)

Thanks for reading :)