Source code indepad ++ / Eclipse for SQL code?

Question

DDL is becoming especially ugly. Is there any option for auto-indenting SQL for Notepad ++? I tried to do this in Eclipse, but the code does not respond to automatic indentation.

Answer 1

Yes, for Notepad ++ there is a free open source T-SQL formatting plugin for Notepad ++ called "Better T-SQL". It is available in the NPP plug-in list "Plugin Manager" (updated automatically every once in a while), and is also available for manual download / installation from here: http://www.architectshack.com/PoorMansTSqlFormatter.ashx

If you just want to check this out without adding to Notepad ++, you can check out the online formatting site:

http://poorsql.com

(disclaimer: I wrote these tools :))

Answer 2

there is another free SQL Formatter plugin for Notepad ++ here: SQLinForm Free Notepad ++ Plug-n