Notepad++/Eclipse sql code auto-indent option?

sql eclipse notepad++ code-formatting
Aubergine picture Aubergine · Oct 24, 2011 · Viewed 54.1k times · Source

DDL gets especially ugly. Is there any option of SQL auto-indenting for Notepad++? I've tried to do it in Eclipse, but the code doesn't react to auto-indent.

Answer

Tao picture Tao · Feb 23, 2012

Yes, there is a free/open-source T-SQL formatting plugin for Notepad++, called "Poor Man's T-SQL Formatter". It is available in the NPP "Plugin Manager" plugin list (gets updated every once in a while automatically), and is also available for manually downloading/installing from here: http://www.architectshack.com/PoorMansTSqlFormatter.ashx

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

http://poorsql.com

(disclaimer: I wrote these tools :))

Related questions

SQLite in Android How to update a specific row

I've been trying to update a specific row for a while now, and it seems that there are two ways to do this. From what I've read and tried, you can just use the: execSQL(String sql) method or the: …

Read More
String to java.sql.Date

I realize this has been asked a lot. I did actually look. I've spent hours looking around and trying to figure this out. I'm supposed to be making a program that stores what amounts to a list of appointments in …

Read More
Lightweight SQL editor for Eclipse

Is there any simple SQL editor in Eclipse? Or do I need to find a simple SQL editor plugin for Eclipse? By simple I mean, the editor does NOT connect to any DB, does syntax highlighting and preferably formatting sql …

Read More