Find out current database name (MSSQL)

Question

If I want to know the server I can use: @@SERVERNAME

Is there an equivalent function for getting database/catalog name.

I know that we can set it in the script with USE statement but what if it wasnt set and I wanted to query within a sproc what db I was using.

score 19 · Accepted Answer · answered Sep 27 '16 at 21:41

19

db_name() will give you the name of the current database.

answered Sep 27 '16 at 21:41

Paul Abbott

@logixologist: if this answer helped you solve your problem, then please [**accept this answer**](http://meta.stackoverflow.com/q/5234/153998). This will show your appreciation for the people who *spent their own time to help you*. – marc_s Sep 28 '16 at 05:04
I would have done it immediately but it has a timer set on it. – logixologist Sep 28 '16 at 13:31

score 7 · Answer 2 · answered Sep 27 '16 at 21:42

7

This should do it:

SELECT DB_NAME() AS DataBaseName

answered Sep 27 '16 at 21:42

Michael Armes

score 5 · Answer 3 · answered Sep 27 '16 at 21:52

5

db_name() will get you the name of database that you using. you can see the result with: select db_name()

answered Sep 27 '16 at 21:52

Ali M

score 3 · Answer 4 · edited Feb 09 '23 at 05:28

3

With the MSSQL queries below, you can check the current database:

SELECT DB_NAME()
GO

master

In addition, if you don't specify a database on sqlcmd, "master" database is used by default.

edited Feb 09 '23 at 05:28

Henry Ecker

answered Sep 15 '22 at 19:30

4 Answers4