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:
- For a task assistant, click Edit in the Commands section.
- For changing database objects by using the Properties view, when
the generated commands are displayed in the Review and Deploy dialog,
click Edit and then click Finish.
Procedure
- Modify the commands that are displayed.
- 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