How can I SELECT the name of the Active Database?

Question

I want to select the name of the Db on which I am running a query and PRINT it.

How can I achieve this in T-SQL?

something like:

DECLARE @ActualDbName VARCHAR(200)
SET @ActualDbName  = -- SELECT ...
PRINT @ActualDbName

This may be what you are looking for. [Get Database Name][1] [1]: http://stackoverflow.com/questions/6774533/how-to-get-database-name-of-sqlserver — dthartman, Jan 23 '14 at 15:00

score 0 · Accepted Answer · answered Jan 23 '14 at 14:56

0

Use the function DB_NAME().

So you would replace your -- SELECT -- with something like:

SELECT DB_NAME() AS [Current Database];

answered Jan 23 '14 at 14:56

Simon Brahan

score 0 · Answer 2 · answered Jan 23 '14 at 14:57

0

Try this...

SELECT DB_NAME() AS DataBaseName

Courtesy : Source

answered Jan 23 '14 at 14:57

M.K

2 Answers2