SQL Assistant v5.0

SoftTree SQL Assistant v5.0 - What's New New Code Analysis and Refactoring Functions - smart object, column, and parameter renaming methods; smart code extraction methods; advanced code dependencies analysis Graphical analysis of dependencies for objects (tables, views, procedures, functions), table and view columns, procedure and function parameters. Code refactoring - Extract View definition from procedural code - 3 clicks method for conversion of a block of code to a view - customizable templates. Code refactoring - Extract sub procedure definition from procedural code - 3 clicks method for conversion of a block of code to a stored procedure or function - customizable templates. Code refactoring - Rename procedure/function in database including automatic discovery of dependencies, code preview before updating, including all dependencies. Code refactoring - Rename table/view in database including automatic discovery of dependencies, code preview before updating, including all dependencies. Code refactoring - Rename table/view column view in database including automatic discovery of dependencies, code preview before updating, including all dependencies. Code refactoring - Rename procedure/function parameter in database including automatic discovery of dependencies, code preview before updating, including all dependencies. Code refactoring - rename local variable - rename local variables in procedures and functions (standalone code loaded in the editor or part of a large script). Syntax checker improvements - highlighting for unused variables. Advanced Code Entry Automation - updated code snippets engine, programmable code snippets using SQL language Support for user-defined interactive prompts. See new $PROMPT$ macro . User-defined programmable macros using SQL code. See new $$..$$ and accompanying macros $CURRENT_NAME$, $CURRENT_SEL$, etc... . Removed certain limitations on the use of functionally similar macros in the same snippet code. For example, $COLUMNS$ and $COLUMNS_KEYS$ macros can be now used in the same code snippet. Improved SQL Intellisense and Code Formatting Improved keyword prompts - preferred keywords and SQL constructs displayed on top of the keyword prompts. You can now customize preferred keywords list to match your preferences. Column popups after ORDER BY and GROUP BY keywords are now feature checkboxes. Multiple columns can be picked at once. While-you-type and standalone code formatters support new formatting options allowing simultaneous use of different cases for keywords and for system functions, for example uppercasing keywords and using mixed or lower case for system functions. New options for handling name delimiters. "Always Add Delimiters" option supports new mode "Only if name = keyword (limited)" You can now customize list of keywords that you also use as object and column names, and which you don't want SQL Assistant to treat as keywords, for example, the default configuration includes ID and Name, names, you can add your own. "Show Keys and Indexed Columns" is preset for all assistance types by default. Primary keys, foreign keys, and indexed columns are displayed by default in column popups and mouse-over hints. Mouse-over hints for table and view columns display hyperlinks for sample data preview and for DDL code view for views. . Mouse-over hints for procedure and function parameters display hyperlinks for procedure/function DDL code view. Improved display of column name popups for PostgreSQL. The popups now indicate auto-generated values and indexed columns. Improved recognition of auto-generated values in various SQL statements. For example, SQL Assistant does not insert references to "timestamp" columns in SQL server when generating code for table INSERT and UPDATE statements. Improved control of column name popups. You can now configure additional symbols that trigger automatic column name popups, for example, you may add <, <>, >, BETWEEN and other symbols to trigger automatic column popup display. SQL Intellisense implemented for CREATE INDEX statement. SQL Intellisense implemented for CREATE OR REPLACE AND COMPILE JAVA SOURCE. Preset code formatting rule added for Oracle VARRAY. Preset code formatting rule added for DEFAULT VALUES in INSERT/UPDATE statements in Transact-SQL. Database name and schema name completion is now supported after Ctrl+Space. That is handy if you work with long names and need to type them often. Behavior change for query suggestions based on code entry history. To avoid accidental insertion of historical queries into the code, historical items are not pre-selected automatically. . Added new option for controlling alias generation. You can now specify name prefixes that you want SQL Assistant to ignore. Database Code Unit Testing Framework New complete database code unit testing framework supports interactive and automated database code unit testing; allows quick bulk setup of unit tests for multiple database projects. New Add-ons Add-ons for Delphi with built-in SQL Editor. Add-ons are available for all Delphi Windows versions from Delphi 2005 to Delphi 2010;. Experimental support for pre-release version of Visual Studio 2010 ( limited testing performed on Windows XP and Vista). Data Import/Export/Generation New test data generator for quickly populating tables and schemas with realistic test data. Supports updates of multiple tables in one project. Enhanced scripting and exporting table data now this feature supports exporting data from multiple tables and views, as well as from multiple schemas. Miscellaneous Syntax Check Results and Messages panes support copying and saving messages. New user-friendly interface for protecting from run-away queries and results. Added handling for XML windows in SQL Server Management Studio. SQL Intellisense is disabled in XML windows. Improved SEH (Structure Exception Handler) for better code quality and support. Added new API functions, including new function for off-line code formatting, with support for multiple files. A number of other minor improvements