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
|