Command Palette Tips and Tricks

The Command Palette provides access to actions that can be performed in Coginiti. This post consists of commands that can improve your productivity when writing SQL in the Query Editor.

Command Palette

To access the Command Palette, press Command+Shift+P (Mac) / Ctrl+Shift+P (Windows). To open the Command Palette via UI, go to View -> Command Palette

View_-__Command_Palette.gif

 

or select Command Palette from the right click context menu

Context_Menu.gif

 

In addition, it's possible to define a keyboard shortcut suitable for you to view the Command Palette. To do this, go to Coginiti top menu -> Keybindings..., search for the Command Palette keybindings, double click on it and set key combination.

Keybindings.gif

 

Command Palette Actions

Add Cursor Above

Open the Command Palette and select the Add Cursor Above action

Add_Cursor_Above_Command_Palette.gif

 

or press Option+Command+Up (Mac) / Alt+Control+Up (Windows)

Add_Cursor_Above_Keys.gif

 

Add Cursor Below

Option+Command+Down (Mac) / Alt+Control+Down (Windows)

Add_Cursor_Below.gif

 

Add Cursors to Bottom

Open the Command Palette and select the Add Cursors to Bottom action

Add_Cursors_to_Bottom.gif

 

Add Cursors to Top

Open the Command Palette and select the Add Cursors to Top action

Add_Cursors_to_Top.gif

 

Add Selection to Next Find Match

Command+D (Mac) / Control+D (Windows)

Add_Selection_to_Next_Find_Match.gif

 

Change All Occurrences

Command+F2 (Mac) / Control+F2 (Windows)

Change_All_Occurrences.gif

 

Copy Expanded SQL Code

Open the Command Palette and select the Copy Expanded SQL Code action

Copy_Expanded_SQL_Code.gif

 

Copy Line Down

Option+Shift+Down (Mac) / Alt+Shift+Down (Windows)

Copy_Line_Down.gif

 

Copy Line Up

Option+Shift+Up (Mac) / Alt+Shift+Up (Windows)

Copy_Line_Up.gif

 

Delete All Left

Open the Command Palette and select the Delete All Left action (Command+Delete (Mac) / Control+Backspace (Windows))

Delete_All_Left.gif

 

Delete All Right

Open the Command Palette and select the Delete All Right action (Control+K (Mac) / Control+K (Windows))

Delete_All_Right.gif

 

Delete Line

Open the Command Palette and select the Delete Line action (Shift+Command+K (Mac) / Shift+Control+K (Windows))

Delete_Line.gif

 

Editor Font Zoom In

Open the Command Palette and select the Editor Font Zoom In action

Editor_Font_Zoom_In.gif

 

Editor Font Zoom Out

Open the Command Palette and select the Editor Font Zoom Out action

Editor_Font_Zoom_Out.gif

 

Editor Font Zoom Reset

Open the Command Palette and select the Editor Font Zoom Reset action

Editor_Font_Zoom_Reset.gif

 

Find and Replace

Command+F (Mac) / Control+F (Windows)

Find_and_Replace_All.gif

 

Find and Replace with Regex

Command+F (Mac) / Control+F (Windows)

Find_and_Replace_with_Regex.gif

 

Fold

Option+Command+[ (Mac) / Alt+Control+[ (Windows)

Fold.gif

 

Unfold

Option+Command+] (Mac) / Alt+Control+] (Windows)

Unfold.gif

 

Fold All

Option+Command+0 (Mac) / Alt+Control+0 (Windows)

Fold_All.gif

 

Unfold All

Option+Command+J (Mac) / Alt+Control+J (Windows)

Unfold_All.gif

 

Fold All Block Comments

Option+Command+/ (Mac) / Alt+Control+/ (Windows)

Fold_All_Block_Comments.gif

 

Fold All Regions

Option+Command+8 (Mac) / Alt+Control+8 (Windows)

Fold_All_Regions.gif

 

Unfold All Regions

Option+Command+9 (Mac) / Alt+Control+9 (Windows)

Unfold_All_Regions.gif

 

Fold Recursively

Option+Command+R (Mac) / Alt+Control+R (Windows)

Fold_Recursively.gif

 

Format Document

Option+Shift+F (Mac) / Alt+Shift+F (Windows)

Format_Document.gif

 

Format Selection

Option+Command+S (Mac) / Alt+Control+S (Windows)

Format_Selection.gif

 

Indent Line

Command+] (Mac) / Control+] (Windows)

Indent_Line.gif

 

Outdent Line

Command+[ (Mac) / Control+[ (Windows)

Outdent_Line.gif

 

Insert Line Above

Shift+Command+Enter (Mac) / Shift+Control+Enter (Windows)

Insert_Line_Above.gif

 

Insert Line Below

Shift+Enter (Mac) / Shift+Enter (Windows)

Insert_Line_Below.gif

 

Move Line Down

Option+Down (Mac) / Alt+Down (Windows)

Move_Line_Down.gif

 

Move Line Up

Option+Up (Mac) / Alt+Up (Windows)

Move_Line_Up.gif

 

Multiple Selection

Hold Option (Mac) / Alt (Windows) and double-click a word

Multiple_Selection.gif

 

Select Text

Hold Shift+Option (Mac) / Shift+Alt (Windows) and drag holding the left mouse button

Select_Text.gif

 

Toggle Block Comment

Option+Shift+A (Mac) / Alt+Shift+A (Windows)

Toggle_Block_Comment.gif

 

Toggle Line Comment

Command+/ (Mac) / Control+/ (Windows)

Toggle_Line_Comment.gif

 

Transform to Lowercase

Open the Command Palette and select the Transform to Lowercase action

Transform_to_Lowercase.gif

 

Transform to Uppercase

Open the Command Palette and select the Transform to Uppercase action

Transform_to_Uppercase.gif

 

Trigger Suggest

Open the Command Palette and select the Trigger Suggest action (Control+Space (Mac) / Control+Space (Windows))

Trigger_Suggest.gif

 

Trim Trailing Whitespace

Option+Command+X (Mac) / Alt+Control+X (Windows)

Trim_Trailing_Whitespace.gif

 

Additional useful features

Find Database Objects

Expand the Discovery panel, click the Search icon and select the DB Objects option

Find_Database_Objects.gif

 

Find Query History

Expand the Discovery panel, click the Search icon and select the SQL history option

Find_Query_History.gif

 

Get Object Structure

Place the cursor to the object

Get_Object_Structure.gif

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request