A. Returning the current database name
The following example returns the name of the current database.
SELECT DB_NAME() AS [Current Database];
GO
B. Returning the database name of a specified database ID
The following example returns the database name for database ID 3.
USE master;
GO
SELECT DB_NAME(3)AS [Database Name];
GO