Home Library Learn Samples Downloads Support Community Forums
4 out of 5 rated this helpful - Rate this topic

DB_NAME (Transact-SQL)

SQL Server 2012

Returns the database name.

Topic link icon Transact-SQL Syntax Conventions

Copy 
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.

Transact-SQL
Copy 
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.

Transact-SQL
Copy 
USE master;
GO
SELECT DB_NAME(3)AS [Database Name];
GO
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.