Abbreviations are set within File->Options->Editors->SQL Editor->Abbreviations.ĪDS supports SQL Scripts encoded in different encoding formats. There are a selection of key combinations to trigger the expansion of an abbreviation. With a few keystrokes an entire block of SQL commands can be inserted.
Although the query window will intelligently decide when to popup options, you may activate the auto-completion feature with the CTRL-SPACE hot key.Ībbreviation Support - User-defined abbreviations, created within the SQL Editor Options, function as customizable autocompletion strings. It determines when to popup tables or columns according to the cursor position in the SQL statement at the time of popup. The Query Analyzer provides auto-completion popups for tables, views, synonyms and their columns. This might give you the impression that Aqua Data Studio’s features do not work. You MUST separate your SQL Statements - If you do not separate your statements, Aqua Data Studio will not be able to identify your current statement or separate them for script execution. Executing as a script will also generate errors from the RDBMS unable to understand your statement. If you try to use it as a separator Aqua Data Studio will not be able to identify your current statement and will give you the impression that Auto-Completion and other features do not work. To keep the parser fast and simple for Auto-Completion and Describe we do not use it. Check out #2 and #3.ĭO NOT separate your statements with a semicolon " " - The reason Aqua Data Studio DOES NOT USE " " AS A SEPARATOR FOR SQL STATEMENTS is because PL/SQL and T-SQL may contain " ". If you do not do this you might get the impression that Aqua Data Studio doesn’t work. This allows Aqua Data Studio to quickly identify which statement you are working on so that it may intelligently provide Auto-Completion, Describe, SQL Template, and Execute as a script on the current statement. Separate your statements with "GO" or "/" - To correctly use all of Query Analyzer’s functionality you need to separate your SQL Statements. Scripts and SQL Statement Separators: ONLY USE GO or / You can quickly change the database you are analyzing in the drop-down menu above the edit window. Toolbar Functionality - The toolbar allows you create a new Query, open scripts, save scripts, save results, copy content, cut content, paste content, undo, redo, find, find and replace, change case, parse, execute, execute current, execute edit, execute explain, stop execution, autocommit, commit, rollback, reconnect, enable autocompletion, refresh the auto schema, run a parameterized script and set the maximum results displayed.
This allows Editing of Collection Data.Click here for a diagram of the toolbar button functions The Keyboard Combination CTRL + ALT + ENTER execute edits the current query in the Query Analyzer. The Keyboard Combination CTRL + E executes the JavaScript commands in the Query Analyzer. Any of the commands executed from within the Query Analyzer can also automatically be stored in The SQL History. The contents of the Query Analyzer can be saved in a variety of ways and in a variety of formats and encodings, allowing reuse as scripts within Aqua Data Studio or for emailing and sharing. When queries are executed in the Query Analyzer their results can be displayed in several ways as text, text history, grid and pivot grid. The MongoJS Pretty Print JSON is another new feature which allows you to display the JSON result in an easy to read format. We've brought all of our easy-to-use and feature rich Query Analyzer functionality to MongoJS Query Analyzer including statement a utocompletion and syntax highlighting. The MongoJS Query Analyzer allows you to view the results in a tree hierarchy, grid results and as text results. The JavaScript statements and queries normally run within a mongodb shell commandline interface can be typed within the MongoJS Query Analyzer and executed (CTRL + E). The MongoJS Query Analyzer is another powerful tool in Aqua Data Studio which can execute JavaScript commands against one of the most widely adopted NoSQL database management systems.
0 kommentar(er)
