T-SQL Tutorial T-SQL Advanced Database Management T-SQL References

T-SQL - SELECT DATABASE



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

Syntax

The syntax of selecting database is given below:

USE DatabaseName;

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

SELECT name FROM sys.databases;

Example: Select a database

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

USE testDB;

To check all the available datasets, the following statement can be used:

SELECT name FROM sys.databases;    

This will produce the result which will be similar to:

name        
--------------
SQLExample1 
SQLExample2 
SQLExample3 
SQLExample4 
SQLExample5 
SQLExample6 
SQLExample7 
SQLExample8 
testDB