"USE" - Setting the Current Database in SQL Server

Q

How to set the current database in SQL Server?

✍: FYIcenter.com

A

Once you are connected to the SQL Server, you should select a database to work with and set it as the current database using the "USE" statement with this syntax:

USE database_name

The following tutorial example shows you how to set "FyiCenterData" as the current database, and create a table in "FyiCenterData":

USE FyiCenterData
GO
Changed database context to 'FyiCenterData'.

CREATE TABLE Links (Name NVARCHAR(32))
GO

SELECT name, type_desc, create_date FROM sys.tables
GO
name    type_desc       create_date
Links   USER_TABLE      2007-05-19 23:05:43.700

 

Managing Databases and Physical Files in SQL Server

⇒⇒SQL Server Database Tutorials

2016-11-24, 764👍, 0💬