Text copied!
Select database
The "USE" command is a powerful tool that allows to switch to a specific database in order to use it to perform operations in SQL. You can easily navigate to a particular database instance within your SQL environment.
In simple words, A single SQL instance can have multiple databases and to access data from a specific database, you first need to select it using the "USE" command. This allows you to switch to the desired database and perform operations such as querying, modifying, or updating the data contained within it.
To select SQL database, you can use the graphical user interface (GUI) or Transact-SQL (T-SQL).
Here's an example of how to select database using T-SQL :
As you can see in below image, [SQL Tutorial] is in use. Let's switch to [BI Tutorial].
1. Run below SQL command in SSMS :
USE [BI Tutorial];
2. Above command will switch to [BI Tutorial] from [SQL Tutorial] database.
That's it! You have successfully switched to [BI Tutorial] from [SQL Tutorial] database using T-SQL.
Here's a step-by-step guide on how to select SQL database using GUI :
1. Click on the "Available Databases" window in SSMS tool.
2. Choose the specific database and click on it.
3. There you go, You have selected [BI Tutorial] database successfully.
That's it! You have successfully switched to [BI Tutorial] from [SQL Tutorial] database using GUI.