Share via


DB_NAME (Transact-SQL)

Returns the database name.

Topic link iconTransact-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)

Help and Information

Getting SQL Server 2005 Assistance