Thursday, November 4, 2010

SQL Beautifier Eclipse Plugin

I created an eclipse plugin that will give you the ability to beautify SQL statements (give some formatting to the SQL to make it easier on the eye).

To install. Download the http://userpages.umbc.edu/~kirkley1/sqlformatter_1.0.0.201011042037.jar jar file and copy it into your 'plugins' folder of your eclipse install.

After copying, load up eclipse. You can find the sql formatter view if you goto Window|Show View then expand the SQL Formatter category folder and select "SQLFormatterView". Paste the unformatted SQL statement in the top text box and hit the 'Format' button. The 'pretty' sql should display in the bottom text box.

Enjoy!