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 :)