DB_NAME (TSQL Function)

Returns the name of the database with the specified ID.

Syntax

DB_NAME ( [database_id] )

Arguments

‘database_id’
optional argument, of type bigint. If omitted, the name of the current database is returned.

Return Types

Returns varchar.

Remarks

Returns NULL if the database doesn’t exist.

Examples

PRINT DB_NAME();
PRINT DB_NAME(100);
PRINT DB_NAME(-123);

The result is:

sales
trashdb
<NULL>