SQL Prompt 3.0 feature set
Complete redesign of the candidate list and schema information panel.
Rewrite of the parser and caching mechanism.
The following new features and enhancements have been added:
provision of categories that group items by object type
support for selecting multiple columns from multiple tables
ability to show data types, primary keys, foreign keys, and aliases in the candidate list
ability to show or hide owner names (or schema names) in the candidate list
ability to resize the candidate list
ability to copy text in the schema information panel
options to select completion keys
improved JOIN support
support for case-sensitive filtering
ability to filter objects when you specify an owner (or schema)
ability to qualify object names and column names
option to automatically insert parentheses for built-in functions and data types
ability to insert object definitions for stored procedures, functions, and views
options to automatically insert closing characters
improved connection management
improved snippet support, including built-in snippets and the ability to specify the insertion point within the snippet code
support for aliases, including custom aliases and prefixes to ignore
improved cache management
ability to switch databases with USE
improved support for large databases
Note that this version provides support only for the query editor windows in
Microsoft® Query Analyzer and
SQL Server Management Studio. Microsoft SQL Server 2005 Express Edition, Visual Studio .NET 2003 and 2005 are
not supported
Best regards,
Tom Harris, Red Gate Software
Complete redesign of the candidate list and schema information panel.
Rewrite of the parser and caching mechanism.
The following new features and enhancements have been added:
provision of categories that group items by object type support for selecting multiple columns from multiple tables ability to show data types, primary keys, foreign keys, and aliases in the candidate list ability to show or hide owner names (or schema names) in the candidate list ability to resize the candidate list ability to copy text in the schema information panel options to select completion keys improved JOIN support support for case-sensitive filtering ability to filter objects when you specify an owner (or schema) ability to qualify object names and column names option to automatically insert parentheses for built-in functions and data types ability to insert object definitions for stored procedures, functions, and views options to automatically insert closing characters improved connection management improved snippet support, including built-in snippets and the ability to specify the insertion point within the snippet code support for aliases, including custom aliases and prefixes to ignore improved cache management ability to switch databases with USE improved support for large databases
Note that this version provides support only for the query editor windows in Microsoft® Query Analyzer and SQL Server Management Studio. Microsoft SQL Server 2005 Express Edition, Visual Studio .NET 2003 and 2005 are not supportedBest regards,
Tom Harris, Red Gate Software