Context Menu

It introduces the features of the context menu that appears when the user right-click in the SQL Editor.

SQL Editor Context Menu

Save

Saves the created SQL statement as a file (.sql). If the file already exists, it will be overwritten

Run SQL

Item
Description

Run SQL

Runs a single SQL at the current cursor location. If the users run it after blocking a specific area of the created SQL, it runs the SQL in the blocked area.

Run All From Cursor

Runs multiple SQL statements from the current cursor to the last SQL statement.

Run Step

Runs a single SQL from where the cursor is currently located, and then moves the cursor to the next SQL statement.

Run SQL Script

Runs all multiple SQLs written in the Editor.

Run Subquery Block

Runs a subquery where the cursor is currently located.

Commit

Performs a function to permanently save data changes made in the current Editor session to the database.

Rollback

Performs a function to cancel data changes made in the current Editor session.

Execution Plan

Feature
Description

Current SQL Plan

Views the SQL Plan for a single SQL where the cursor is currently located.

Show SQL Trace

Runss a single SQL at the current cursor and views the SQL Trace information.


Cut

Cuts the selected area.

Copy

Copies the selected area.

Paste

Pastes the copied content.

Select All

Selects everything.

Undo

Undo an action.

Redo

Redo a canceled action.

Format

Feature
Description

Format All

Increases readability by making all irregular and hard-to-read SQL look nice.

Format

Imcreases readability by making a single irregular and unreadable SQL more presentable.

Trim Spaces

Automatically removes unnecessary spaces at both ends of lines of code or text.

Word Wrap (On / Off)

Automatically wrap long lines of text to fit the size of the editor window so the users can see the whole thing without scrolling horizontally.

Single Line Comments

A feature that allows the users to comment a single line of text using the '--' symbol in SQL.

Multi Line Comments

Uses the '/* */' symbol in SQL to comment multiple lines of text at once.

Convert Case

Features
Description

Sentensize

Converts the first letter of a sentence to uppercase and the rest to lowercase.

Upper Case

Capitalizes all alphabets in the selected text.

Lower Case

Converts all alphabets in the selected text to lowercase.

Capitalize

Capitalizes the first letter of each word in the selected text and converts the rest to lowercase.

Invert Case

This function reverses the case of the selected text, converting uppercase letters to lowercase letters and lowercase letters to uppercase letters.

Template

Opens the SQL Template Tab.

Preference

Opens the Preferences menu. The users can customize themes, editor settings, shortcuts, and more.

Last updated