Getting Database Name using ID and vice versa using SQL Server

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

Syntax:

-- Get Name from ID.

SELECT DB_NAME('DatabaseID') AS [DatabaseName from ID];

 

-- Get ID from Name.

SELECT DB_ID('DatabaseName')) AS [DatabaseID from NAME];

Usage:

-- Get Name from ID.

SELECT DB_NAME(DB_ID()) AS [DatabaseName from ID];

 

-- Get ID from Name.

SELECT DB_ID(DB_NAME()) AS [DatabaseID from NAME];

OUTPUT:

DatabaseName from ID

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

Northwind

 

(1 row(s) affected)

 

DatabaseID from NAME

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

26

 

(1 row(s) affected)

Thanks for reading :)