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, 3115🔥, 0💬
Popular Posts:
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...