SQL Script Pane – Overview¶
The SQL Script Pane is the key area of the Meta Query tab. It contains the text of your SQL script(s) and resembles the interface of a typical SQL editor:
Multiple tabs can be opened so you can view/edit several scripts simultaneously. There are 3 additional navigation controls for shifting left, right, and opening the whole list of tabs, and New & Open catalog icons.
A toolbar contains the major actions you can perform
The main editing area shows your SQL script and provides syntax highlighting
SQL Script Storage¶
There are two possibilities to store your custom SQL scripts:
- Save to the Script Catalog: this catalog is located on MMTE Server and its scripts are available to all MMTE users
- Save to a file: you choose where your script should be stored in file system of your MMTE Client computer; it will not be available to other MMTE users
Context Menu¶
Right-click anywhere in the script editing area to open a context menu that contains the following commands:
- Undo
- Redo
- Cut
- Copy
- Paste
- Delete
- Select All
- Insert Env ID
Keyboard Shortcuts¶
The following keyboard shortcuts are available in the SQL Script Pane:
| Shortcut | Description |
|---|---|
| Ctrl + Z | Undo your last edit in SQL Script editor |
| Ctrl + Y | Redo your last edit in SQL Script editor |
| Ctrl + Shift + F | Format all SQL query in a standard way |
| Ctrl + Shift + O | Open MetaMiner SQL Script Catalog where you can select a SQL script to load from MMTE Server |
| Ctrl + T | Open a new SQL script tab |
| Ctrl + O | Open a SQL Script from the specified file |
| Ctrl + S | Save the selected SQL Script to a file |
| Ctrl + Shift + S | Save the selected SQL Script to SQL Script Catalog |