How do you check which DB we are using?
SHOW databases using SQL Server Management Studio (SSMS)

  1. Step 1: To avoid any permission issues, start SSMS in administrator mode.
  2. Step 2: The Object Explorer window will display on the left-hand side of the screen once the connection is established.
  3. Step 3: Click the plus(+) icon to expand the Databases folder.

You can run command sp_who2 in MS SQL server and you will see the list of connections and queries that are currently running and using the SQL database with more details like SPID, Database Name, query, Wait time and some more.Using SQL Server Management Studio

  1. In Object Explorer, select the plus sign next to the database that contains the view to which you want to view the properties, and then click the plus sign to expand the Views folder.
  2. Right-click the view of which you want to view the properties and select Properties.

How do I find the name of the current database in SQL : You can use the 'dbname' option to retrieve the name of the current database. This option returns the identifier of the database to which the client session is currently connected.

How to check DB in SQL Server

To view a list of databases on an instance of SQL Server

  1. Connect to the Database Engine.
  2. From the Standard bar, select New Query.
  3. Copy and paste the following example into the query window and select Execute. This example returns a list of databases on the instance of SQL Server.

How to check DB in SSMS : How to Check SQL Server Database Size

  1. Launch Microsoft SQL Server Management Studio (SSMS).
  2. On the File menu, click “Connect Object Explorer”.
  3. Click “Connect”.
  4. Upon connection, click “New Query” and enter one of the following as the query:
  5. Click “Execute”.
  6. Review the output, as illustrated below.

To view a list of databases on an instance of SQL Server

  1. Connect to the Database Engine.
  2. From the Standard bar, select New Query.
  3. Copy and paste the following example into the query window and select Execute. This example returns a list of databases on the instance of SQL Server.


SELECT db_name() should do the trick.

How to check db in MySQL

Run the following query to show list of databases: SHOW DATABASES; You can run this statement from MySQL Command Line Client, MySQL Shell, as well as from any GUI tool that supports SQL—for example, dbForge Studio for MySQL. MySQL returns the results in a table with one column—Database.Use SQL Server Management Studio

  1. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
  2. To see a list of all databases on the instance, expand Databases.

Right click the server group and select New Query and type: DECLARE @tbl_name nvarchar(128)='''tblWareHouse'''; DECLARE @sql nvarchar(2000) = N'USE SELECT db_name() from sys. tables where is_ms_shipped=0 and name = '+@tbl_name; EXEC sys.

Click on the Database link in the Web Tools section of your hosting control panel. In the Manage Databases section the server your database is hosted on is shown in the Server column.

How to see db in MySQL : Run the following query to show list of databases: SHOW DATABASES; You can run this statement from MySQL Command Line Client, MySQL Shell, as well as from any GUI tool that supports SQL—for example, dbForge Studio for MySQL. MySQL returns the results in a table with one column—Database.

How to check database in MySQL using CMD : Enter one of the following mysqlcheck commands at a command or shell prompt:

  1. To check the tables in all of the applicable databases on the server: mysqlcheck –all-databases.
  2. To check all of the tables in a single database: mysqlcheck –databases db_name. Example: mysqlcheck –databases reporter.

How to get all DB name in SQL Server

The procedure to get the Server Name and Database Name from the SQL Server Analysis Services is as follows:

  1. Open the SQL Server Management Studio with the server type as the Analysis Services.
  2. In the Object Explorer window, right click the database to get the server and database names, and click Properties.


Right click the server group and select New Query and type: DECLARE @tbl_name nvarchar(128)='''tblWareHouse'''; DECLARE @sql nvarchar(2000) = N'USE SELECT db_name() from sys. tables where is_ms_shipped=0 and name = '+@tbl_name; EXEC sys.To list all MySQL databases using a query, you can use the SQL statement “SELECT schema_name FROM information_schema. schemata;”.

How do I identify SQL Server : Use the following steps from the command prompt to determine what version of SQL you are running. On the workstation that SQL is installed, choose Start > Run, and enter cmd in the Open field, and then press Enter to launch a command prompt window. Type select @@version and press Enter.