You use the Script Editor to add content to a new script, to edit existing scripts, and to run and delete scripts in the script repository.
- Editing an Existing Script
Learn how to edit an existing SQL script. - Script Editor Controls
Controls and buttons available within the Script Editor.
5.6.1 Editing an Existing Script
Learn how to edit an existing SQL script.
To edit a SQL script:
- On the Workspace home page, click SQL Workshop and then SQL Scripts.
The SQL Scripts page appears.
- You can load a script into the editor as follows:
In Icons view, click the script icon.
In Report view, click the Edit icon.
The Script Editor appears.
- Edit the script.
Note that new lines are automatically indented to the previous line start column. Other features of the Script Editor include:
Undo - Use to undo the last edit.
Redo - Use to reapply the last undone edit.
Find - Click the Find icon (which resembles a magnifying glass) to perform a basic search.
Replace - Click the Replace icon (which resembles a two-sided arrow) to replace existing code.
Cut, Copy, and Paste - Use standard edit controls to cut, copy and paste content in the Script Editor.
See AlsoHow to Learn SQL FastAuto Complete - Click the Auto Complete icon to complete the command.
- Click Apply Changes to save your script.
The SQL Scripts page appears.
You can test your script during editing by running the script to reveal errors.
See Also:
5.6.2 Script Editor Controls
Controls and buttons available within the Script Editor.
Table 5-1describes the buttons and controls available within the Script Editor
Table 5-1 Buttons and Controls within the Script Editor
Button | Descriptions |
---|---|
Cancel | Cancel the editing session and exit the Script Editor without saving changes made since the last save. |
Download | Saves a copy of the current script to your local file system. Enter a name for the script on your local file system and a directory path. |
Delete | Removes the current script from the Script Repository. |
Save | Saves the currently script. Save is disabled if you edit the Script Name. Instead use Apply Changes. |
Apply Changes | Saves the script and returns to the SQL Scripts report. |
Run | Submits the script for execution. |
Undo (Ctrl+Z) | Removes, or undoes, the most recent line edit made in the Script Editor. |
Redo (Ctrl+Y) | Repeats the most recent line edit made in the Script Editor. |
Find (Ctrl+F) | Click the Find icon (which resembles a magnifying glass) to perform a basic search. |
Replace (Ctrl+Shift+F) | Click the Replace icon (which resembles a two-sided arrow) to replace existing code. |
See Also: