web analytics
Instant SQL Formatter Options
Posted: Saturday, February 6, 2016 9:12:26 AM

Rank:Advanced Member
Groups: Member
Joined: 12/14/2015
Posts: 189
Points: 1098

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.

Posted: Saturday, February 6, 2016 9:12:26 AM
Posted: Wednesday, August 15, 2018 3:58:01 AM
Groups: Member
Joined: 8/15/2018
Posts: 1
Points: 3

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

Users browsing this topic

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

© 2018 Digcode.com. All rights reserved.