Managing Database Connections within the Transact-SQL Editor
You can use the Transact-SQL (T-SQL) editor whether you are connected to a database or not. You can connect to only one database at a time, but you can connect to a different database, even one on a different server, without losing the contents of your editor session.
In This Section
- How to: Connect to Different Databases in the Same Editor Session
Describes how you can switch from one database to another without starting a new editor session.
- Considerations for Offline Editing
Provides an overview of what you can and cannot do in the T-SQL editor while you are not connected to a database.
- How to: Disconnect from Databases
Describes how you can disconnect from the current database and work offline.
- How to: Connect to a Database in the T-SQL Editor
Describes how you establish a connection to a server and database in the T-SQL editor.
Related Sections
- Transact-SQL Editing Essentials
Contains topics that describe the most important editing tasks that you can perform by using the T-SQL editor.
- Script Analysis and Execution in the Transact-SQL Editor
Contains topics that help you analyze and run your scripts and queries in the T-SQL editor.
- Working with Database Objects
Provides an overview and links to topics that describe how you create, modify, and validate changes to database objects such as tables, stored procedures, and functions.