Collections:
"USE" - Setting the Current Database in SQL Server
How to set the current database in SQL Server?
✍: FYIcenter.com
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
2016-11-24, 2912🔥, 0💬
Popular Posts:
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...