Regardless of the approach that you use to create an SQL
statement or an XQuery statement in the SQL and XQuery editor, the statement
is connected to a specific database. However, you can connect to a
different database by changing the database connection.
Before you begin
The database that you are connected to determines the information
that is available when you use content assist. Your database connection
also might affect the results when you run the SQL or XQuery statement.
Prerequisite: To
change a database connection, the SQL or XQuery statement must be
open in the SQL and XQuery editor.
About this task
To change a database connection in the SQL and XQuery editor:
- Right-click in the SQL and XQuery editor, and then click Use
Database Connection on the pop-up menu.
- Select a different connection profile in the Select
Connection Profile wizard, and then click Finish.