Returns the database name.
.gif)
Transact-SQL Syntax Conventions
DB_NAME ( [ database_id ] )
-
database_id
-
Is the identification number (ID) of the database to be returned. database_id is int, with no default. If no ID is specified, the current database name is returned.
nvarchar(128)
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
Reference
DB_ID (Transact-SQL)
Metadata Functions (Transact-SQL)
sys.databases (Transact-SQL)
Help and Information
Getting SQL Server 2005 Assistance