Returning the Current Database ID and Name : DB_ID « System Settings « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. System Settings
3. DB_ID

4> SELECT DB_ID() DatabaseID, DB_NAME() DatabaseNM
5> GO
DatabaseID DatabaseNM

---------- -------------------------------------------------------------------------------------------------------------
-------------------
         1 master


(1 rows affected)