Skip to content

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:

SQL Script Pane

icon 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.

icon A toolbar contains the major actions you can perform

icon 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
Back to top