
Set the search to use Regular Expressions. Open the Command Palette and type "replace.". With a Regular Expression search and replace, we search for a text pattern instead of exact text, which lets you modify more text in one go. Search and Replace with Regular Expressions A foldable region starts at a line whose next line has a greater indent and ends when the indent is the same as the starting line. 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. #Conneting in aqua data studio code#
Quickly comment lines or blocks of code.First tip: Become familiar with the Command Palette.