System and Application Softwares
Tools and Utilites
Instant SQL Formatter
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.
Many conventional sql formatting tools use ad hoc string processing methods to implement the formatting process. This can work pretty well for many sample sqls. But it often fails when multiple statements per line, nested comments, comments around incomplete blocks of code or keywords, etc. are encountered, as they always are in large systems of software. The result of such failure is badly formatted sql query, or worse, sql text that is no longer is acceptable to the database.
SQL Pretty Printer(Instant sql formatter) parse the sql query according to the sql dialect lexical and syntax rules. This ensures that the syntax structures found match those of the corresponding sql dialect, and enables a more flexible and accurate layout control. As a result, a more user friendly formatted sql will be generated.
If there are syntax errors in the SQL, the internal parser will not generate the parse tree, so SQL will not be formatted.(Since Ver3.0, if you set output type to keeplayout, output still can be generated, and you still can modify case, remove comment, and generate text, html, rtf output)
SQL Pretty Printer supports DB2, MySQL, MS Access, MS SQL Server(T-SQL) and Oracle including PLSQL.
Thanks for the information! I want to share my user experience too, so here is my favorite handy tool for formatting SQL Server queries - Online SQL Formatter
© 2018 Digcode.com. All rights reserved.