6.6 Using the Script Editor
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.
Parent topic: Using SQL Scripts
6.6.1 Editing an Existing Script
Learn how to edit an existing SQL script.
To edit a SQL script:
You can test your script during editing by running the script to reveal errors.
See Also:
Parent topic: Using the Script Editor
6.6.2 Script Editor Controls
Controls and buttons available within the Script Editor.
Table 6-1 describes the buttons and controls available within the Script Editor
Table 6-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. |
Create App |
Launches the Create App Wizard based on the table. Only works with scripts that add tables to the schema. Tip: You must run the script that adds tables to the schema first. |
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+Shift+Z) |
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. |
Auto Complete (Ctrl+Space) |
Click the Auto Complete icon (which resembles upper case letter A) view possible auto complete suggestions. |
Context Menu |
Right-click and select one of the following:
|
Command Palette (F1) |
Right click to display a context menu and select Command Palette. The Command Palette includes over 80 commands including:
|
Multi Cursor Selection |
|
Settings menu |
The Settings menu displays on the right side and includes the following options:
|
See Also:
Parent topic: Using the Script Editor