Is there a variable like @@ ServerName, but for the database name?

Question

I need to get the name of the database I'm currently running in (for use in the URL column).

I know that I can get the server name using @@ ServerName. But no @@ DatabaseName.

How can I get the database that is currently running?

+3

Vaccano May 26, '11 at 17:44

3 answers

You can use DB_NAME () to get the database name.

SELECT DB_NAME() AS DataBaseName

+1

Bblake May 26, '11 at 17:47

You can use this function to get the name of the database you are currently using.

select DB_NAME ()

0

Kapil May 27 '11 at 10:44

Redfilter · Accepted Answer · 2011-05-26T17:46:18+0000

Try using this:

select DB_Name()

Example database change:

use master
select DB_Name()
use model
select DB_Name()