user2149838
Reputation: 49
How to find the name of the database currently used?
I am working on Microsoft SQL server management studio. I have 15 different databases under the Databases folder. All the databases have similar structure and tables. I wrote a query that will work on any database. However i want to know how can I find out the name of the currently used database, I want this to show in my result set. Please advise?
Upvotes: 2
Views: 112
Answers (2)
user2149838
Reputation: 49
DB_NAME() method can get you the name of the current database. Answered by StuartLC.
Upvotes: 0
Martin Smith
Reputation: 453756
Sounds like you need the DB_NAME() function.
It accepts an optional database_id parameter. If omitted it returns the name of the current database.
Upvotes: 3
Related Questions
- Find out current database name (MSSQL)
- How do I find out which database a connection is using?
- How to find Database Server Name
- How to find database name of any table
- How to display the correct database name?
- How to find the database name using the table name?
- Get database name of table using SQL Server
- How to identify hardcoded database name - SQL Server 2008 r2
- Get's database's name?
- How do i find out in sql what db name I'm connected to