When you use the Database Explorer toolbar to create an SQL statement
or an XQuery 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 or XQuery statement.
You can also use a database connection to connect to a different
database.
Prerequisite: To use a database connection, the SQL
or XQuery statement must be open in the SQL editor.
To use a database connection in the SQL editor:
- Right-click in the SQL editor, and then click Use Database
Connection on the pop-up menu.
- Complete the pages in the Connection Selection wizard, and then
click Finish.