DB_NAME (Transact-SQL)
Returns the database name.
.gif "Topic link icon")
Transact-SQL Syntax Conventions
Syntax
DB_NAME ( [ database_id ] )
Arguments
- 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.
Return Types
nvarchar(128)
Examples
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
See Also
Reference
DB_ID (Transact-SQL)
Metadata Functions (Transact-SQL)
sys.databases (Transact-SQL)