Using database connections in the SQL editor

When you use the Database Explorer toolbar to create an SQL statement in the SQL editor, the statement is not connected to a database. You can connect to a database to use content assist or run the SQL statement.

You can also use a database connection to connect to a different database.

Prerequisite: To use a database connection, the SQL statement must be open in the SQL editor.

To use a database connection in the SQL editor:
  1. Right-click in the SQL editor, and then click Use Database Connection on the pop-up menu.
  2. Complete the pages in the Connection Selection wizard, and then click Finish.
Related tasks
Creating SQL statements in the SQL editor by using the Database Explorer toolbar

Feedback