Microsoft SQL Server - Transact-SQL Examples: Specifying the Current Database

	Specifying the Current Database

Overview

To specufy the current database, use USE followed by the name of the database.

To visually select a database click the arrow of the combo box and select the desired database:

Available Databases

To programmatically specify the current database, in a Query window or at the Command Prompt (including PowerShell), type the USE keyword followed by the name of the database. The formula to use is:

USE DatabaseName;

Here is an example:

USE GovernmentStatistics;