Wednesday, December 7, 2016
Most
Useful Shortcuts:
|
Block Comment
|
CTRL+B
|
Comment selected
lines
|
|
Uncomment
|
CTRL+SHIFT+B
|
Uncomment Selected
lines
|
|
Format Code
|
CRTL+SHIFT+F
|
Format and indent
code.
|
|
Describe
|
F4 or ALT + Enter
|
Opens a new window
describing the table
|
|
Lower case
|
CRTL+L
|
Convert all the text to lowercase
|
|
Describe Select
Query
|
CRTL + F9
|
Opens a new window
describing the select statement
|
|
Execute Statement
|
F9
|
Run SQL code and
show results in Script Output tab
|
|
Execute Script
|
F5
|
Run SQL code and
show results in Data Grid
|
|
SQL Recall
|
F8
|
Opens a section
which shows all the SQLs run
|
|
Previous SQL
Recall statement
|
ALT + up
|
Acts like history
navigation in bash shell for SQL commands
|
|
Next SQL Recall
statement
|
ALT + down
|
Acts like history
navigation in bash shell for SQL commands
|
|
Next Navigator
Node
|
CRTL+PgDn
|
Goes not next
statement block in the editor
|
|
Previous Navigator
Node
|
CRTL+PgUP
|
Goes not previous
statement block in the editor
|
|
Quick Template
|
CRTL+Space
|
Opens a prompt on
the editor with all template for code blocks like begin end, for loop,etc
|
Helpful
Views:
|
View>Code
Snippets
|
Provides sample
code snippets like hints, date formats, conversion functions (quick
alternative to googling for synrax)
|
|
View>Object
Palate
|
Used for building
queries by selecting object name and column name by dragging and dropping
them into editor
|
Thank you for sharing such a useful article. I had a great time. This article was fantastic to read. Continue to publish more articles on
ReplyDeleteData Engineering Solutions
Data Analytics Service Provider
Data Modernization Services
Machine Learning Services