General MySQL Oracle SQL Server

"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

 

⇒ "DROP DATABASE" - Deleting Databases in SQL Server

⇐ Simplest Way To Create New Databases in SQL Server

⇑ Managing Databases and Physical Files in SQL Server

⇑⇑ SQL Server Database Tutorials

2016-11-24, 4411🔥, 0💬

General MySQL Oracle SQL Server