SQL Beautifying

Hi!

Can somebody give me a hint on how to beautify SQL statements with PHPStorm?
Or is there maybe a built-in function for this?

Would be very glad for advice.

Thanks a lot!

4 comments
Comment actions Permalink

Hi John,

Generally speaking it is "Code | Reformat Code..." and settings are available at "Settings | Code Style | SQL", but it is extremely limited (IMO) at the moment.

There are some improvements in this area already, but those changes are not yet available in 5.0.x branch unfortunately (currently only in IntelliJ IDEA v12 EAP). It should be available in one of the PhpStorm's next major version (v6, or maybe even v5.x).

0
Comment actions Permalink

alright, thanks for the information!

0
Comment actions Permalink

When is this expected to be in production?

Right now I keep Universal SQL Editor open in the background to beautify my sql code, then copy it into PHPStorm.

BTW, PHPStorm is an AMAZING piece of software. Wish I would of been using it sooner!

 

Thanks

0
Comment actions Permalink

The feature requests posted by Andriy are already implemented, you can check that in the Fixed in build field.

0

Please sign in to leave a comment.