Hey, is there a good free tool out there that can also format complex queries?
Thanks :-)
+1
A:
Have you tried google?
If you are using SQL Server then you could use the query builder in SQL Management Studio
confusedGeek
2010-07-22 15:00:54
Yeah, I tried google, but all tools I find, dont format the way I want or dont format at all.
grady
2010-07-22 15:03:37
I don't see how this is helpful. From looking at the first several, I can't tell which, if any, of these "free sql query tool"s support formatting.
Ken
2010-07-22 15:04:15
Management Studio writes some of the most heinously formatting SQL. I tell my developers not to use it or require that they reformat the SQL so that it's readable.
Thomas
2010-07-22 16:13:55
A:
Sequel Pro If using OS X otherwise just work out what you need then develop your query using your knowledge and use the command line tool(my personal favourite:)).
Dean
2010-07-22 15:03:42
+1
A:
I've always been a fan of navicat - http://www.navicat.com
Their lite version is free, but it still comes with the sql beautifier - http://www.navicat.com/en/products/navicat_premium/premium_feature.html
As an added bonus occasionally you'll find some chinglish hiding in odd places.
scaryman
2010-07-22 15:09:20
A:
Notepad++ supports formatting for many languages including SQL.
Christopherous 5000
2010-07-22 15:13:13
+1
A:
T-SQL Tidy is a very good online SQL formatter/beautifier.
It has a lot of formatting options. Though it's targeted to T-SQL, it should work with most SQL dialects.
MicSim
2010-07-22 15:21:56
A:
There is a free online Instant SQL Formatter. The site also sells some other versions (add-in for Visual Studio, for example), but the online version is free.
Aaron D
2010-07-22 23:18:48