SQL Pretty Printer can automatically format your SQL code files. You can also use it to publish well formatted and colored SQL scripts (in HTML or RTF) on the web, blogs, forums, articles or books. It also allows you to switch from team “standard” formatting to individually preferred formatting and back for better uniformity in your source control repository.
v3.2 [Mar 16, 2011]
- New format option for execute command: exec_first_paramater_in_newline, exec_parameters_style, exec_parameters_comma_option, exec_parameters_align_value;
-New format option for idenetifier: case_table_name, case_column_name, case_alias_name, case_variable_name, case_prefix_identitfer and identifier_prefix_list;
- New format option of subquery: Subquery_Newline_After_IN,Subquery_Newline_After_EXISTS,Subquery_Newline_After_ComparisonOperator, Subquery_Newline_Before_ComparisonOperator;
- Fix a bug that menu and toolbar disappeared in vs2010 after first installation.
- If there are some SQL statements with syntax errors, other SQL in the same script still can be formatted correctly.
- Support interval expression in plsql
- Support BULK COLLECT INTO clause of EXECUTE IMMEDIATE
- Support sql statement that block statement that follow declare statement directly.
- Fix a bug that can ouput [WINRDB7\SQLMaster] correctly in RTF output.
- Fix a bug that can't format join clause correctly in this sql: SELECT * FROM S1 natural join w3 LEFT OUTER JOIN S2 ON S1.S = S2.S
- Improve format result if there is a comment after WHERE keyword directly.
- Performance improved, Lots of minor bugs fixed.
Feature-rich relational database known for its high performance and excellent concurrency
