Changing database connections in the SQL and XQuery editor

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.

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.

To change a database connection in the SQL and XQuery editor:
  1. Right-click in the SQL and XQuery editor, and then click Use Database Connection on the pop-up menu.
  2. Select a different connection profile in the Select Connection Profile wizard, and then click Finish.
Related tasks
Creating SQL and XQuery statements in the SQL and XQuery editor by using the Data Source Explorer toolbar

Feedback