Any SQL formatter plugin for Eclipse avaialble?

Question

I am not finding any standard open source sql formatter eclipse plugin on net. I am using eclipse helios. I can find Edit-->FormatSQL but that does not seems to be working. Found one at http://ventralnet.blogspot.in/2010/11/sql-beautifier-eclipse-plugin.html but formatting is not good. Any suggestion will be helpful. For info I am using sqlserver sql scripts.

Answer 1

Toad eclipse-extension (community edition), will get you almost everything you want in an SQL editor, including formatting (ctrl+shif+f). Search for 'toad' in eclipse market place. It has very good Oracle, MySQL and PostgreSQL support.

Take a look at Installation instructions and screenshots.

Another option is http://dbeaver.jkiss.org/download/#eclipse (Which is very good and also has a standalone version)

Answer 2

Some of my favorites are:

Eclipse SQL Explorer at: http://eclipsesql.sourceforge.net

DBViewer at: http://www.ne.jp/asahi/zigen/home/plugin/dbviewer/about_en.html