With one click, the built-in Automate functions allow inserting frequently used statements such as SELECT, DELETE or INSERT in your code. Another powerful and flexible feature is the Abbreviation support…
Aqua Data Studio supports SQL, JSON, AquaScript, Text, HTML, XML, JavaScript, and Java Editors. Features such as syntax highlighting, autocompletion, code folding, find and replace, lens mode, zooming, punctuation completion,…
Invoke query results in an editable, Excel-like grid. The Execute Edit feature is useful for altering, inserting, deleting, cloning and formatting data in the Table Data Editor.
Aqua Data Studio’s Visual Explain Plans, available for multiple database platforms, provide a visual display and statistics of an execution plan for a query, allowing for query tuning to enhance…
Speed up the creation of your SQL scripts with the autocompletion feature for database tables, columns and views. Autocompletion is invoked instantly as you type in the SQL Editor. Aqua…
The SQL Editor allows you to quickly format SQL statements for readability. Ctrl+B invokes the various options to beautify SQL keywords, case keywords, alignments, operators, punctuation marks, line breaks and…
With the Parameterized Scripts feature, you can define variables in your SQL Scripts using a leading “&”. Once you run the script, a popup will prompt you to enter the…
Augment your datasets with calculated fields and parameters. Users may add calculated fields which are new fields in your dataset where the values are based on user defined expressions of…
Table calculations allow you to add data to your worksheet with formulas that work on the data of your visualization. Create calculations of moving averages, running totals, percent of total…
An advanced Query Analyzer allows you to connect to any database server and execute SQL Queries. SQL formatter, syntax coloring, and autocomplete features save you time in writing SQL statements.
