SQL Tutorial SQL Advanced SQL Database SQL Resources
Python Java C++ C C# PHP R SQL DS Algo InterviewQ

SQL - SELECT DATABASE



When there are multiple databases in the SQL Schema, then before starting any operation on a given database, that database need to be selected. The SQL USE statement is used to select any existing database in the SQL schema.

Syntax

The syntax of selecting database is given below:

USE DatabaseName;

To see the list of databases available in RDBMS, the following command can be used:

SHOW DATABASES;

Example: Select a database

To select a database with name testDB, the following query can be used:

SELECT testDB;

To check if the SQL Schema contains the given dataset, SHOW DATABASES; command can be used:

SQL > SHOW DATABASES;
+-------------+
| Database    |
+-------------+
| SQLExample1 |
| SQLExample2 |
| SQLExample3 |
| SQLExample4 |
| SQLExample5 |
| SQLExample6 |
| SQLExample7 |
| SQLExample8 |
| testDB      |
+------------ +
9 rows in set (0.00 sec)

5