
Mac: opt + cmd + ĪDS determines a foldable region by evaluating the indentation of lines. Want to hide a region of a query, e.g., hide a sub-query while editing the outer query. This also works for tables, i.e., SELECT table.*. Press Enter to replace * with all column names. You should see a concatenated list of all column names Trigger IntelliSense (Windows: ctrl + space, Mac: ctrl + space). Known as Star Expansion, this takes an asterisk in the SELECT clause and replaces it with all column names. On Windows, the Join Lines command is not bound to a keyboard shortcut but can be set in Keyboard Shortcuts. On Mac, the shortcut for this is control + j Got a compact statement that could fit on one line? Use the Join Lines command.
Familiarising yourself with this tool will help you get a lot more out of Azure Data Studio. The Command Palette is designed for performing actions from the keyboard. To access the Command Palette in Azure Data Studio press: Commands do things such as modify your current code, connect to a data source, or change a setting. The Command Palette is the searchable prompt where Azure Data Studio's many commands are accessed.
Get information about a Database Objectįirst tip: Become familiar with the Command Palette. Work on one query while referring to another. Search and Replace with Regular Expressions. Make azure data studio default application code#
Quickly comment lines or blocks of code. First tip: Become familiar with the Command Palette.