Disconnecting scripts from databases in the SQL and XQuery editor

When you work with a script that contains SQL and XQuery statements in the SQL and XQuery editor, the script usually is connected to a database. However there might be times when you want to disconnect the script from the database; for example, to work offline.

Before you begin

Open the script in the SQL and XQuery editor.

About this task

The database that a script is 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. SQL and XQuery statements can be validated independently of the database connection.

The connection string for the current database is shown on the left in the top border of the editor. If the string No Connection is displayed, the script is not connected to a database. You can select a database connection for the script by clicking the string to open the Select Connection Profile wizard.

Procedure

To disconnect a script from a database in the SQL and XQuery editor:

Open the Configuration tab and then select No Connection from the Connection list.

Results

The script that is open in the SQL and XQuery editor is not connected to a database. No connection string is shown in the top border of the editor.

If you want to validate the statements in the script while it is not connected to a database, select the parser to use in the Validation tab.


Feedback