Editing commands manually with the SQL and XQuery editor

You can use the SQL and XQuery editor to manually edit the commands that are generated by a task assistant or by changing database objects.

Before you begin

The generated commands must be displayed in the SQL and XQuery editor. To open the editor where the generated commands will be displayed, complete either of these tasks:

Procedure

  1. Modify the commands that are displayed.
  2. Run the commands. You can use the following options to run the commands:
    • Run the commands directly from the editor.
    • Save the commands to a file and then run the commands from the saved file.
    • Use the editor to start the Job Manager, where you can schedule a time to run the command script.

Results

Any changes that you make in the SQL and XQuery editor are not reflected back to the commands that are displayed in either the task assistant or the Review and Deploy dialog.

Feedback