DB_NAME
Returns the database name.
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
sysname
Examples
SELECT DB_NAME (DB_ID()) as [Current DB name];