I want to beautify the SQL Queries I write.
我想美化我编写的SQL查询。
What free tools exist that allow for SQL query formatting?
有哪些免费工具允许SQL查询格式化?
6 个解决方案
#1
52
PoorMansTSqlFormatter is a free and open-source online beautifier, with offline SSMS Add-In, command-line beautifier tool, and Notepad++ plugin.
PoorMansTSqlFormatter是一个免费的、开源的在线美化工具，具有离线SSMS插件、命令行美化工具和记事本+插件。
The project aims to format any T-SQL (2000 or later) script, no matter the length or complexity.
该项目旨在格式化任何T-SQL(2000或更高)脚本，无论其长度或复杂性如何。
Hope this helps!
希望这可以帮助!
#2
17
T-SQL Tidy is a very good online SQL formatter/beautifier.
T-SQL Tidy是非常好的在线SQL格式化程序/美化器。
It has a lot of formatting options. Though it's targeted to T-SQL, it should work with most SQL dialects.
它有很多格式化选项。尽管它的目标是T-SQL，但它应该适用于大多数SQL方言。
#3
6
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.
有一个免费的在线即时SQL格式化程序。该网站还出售其他一些版本(比如Visual Studio的插件)，但在线版本是免费的。
#4
2
red Jul 22 '10 at 15:13 @Christopherous 5000
red Jul 22 '10 at 15:13 @Christopherous 5000。
I was looking for the same in notepad++ and found a link that gives an idea of how to create your own formatting with macros: http://peoplesoft.wikidot.com/formatting-sql-in-notepad. Seems like it would work, but I'm going to use one of the SSMS Add-ins above. (Less work) Thanks!
我在notepad++中寻找相同的内容，并找到了一个链接，该链接提供了如何用宏创建自己的格式的方法:http://peoplesoft.wikidot.com/formatting-sql-in-notepad。看起来是可行的，但我将使用上面的ssm插件之一。(不工作)谢谢!
#5
1
I've always been a fan of navicat - http://www.navicat.com
我一直是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
他们的lite版本是免费的，但它仍然附带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.
作为额外的奖励，偶尔你会发现一些中式英语藏在奇怪的地方。
#6
0
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:)).
Sequel Pro如果使用的是OS X，那么你需要的是什么，那么就用你的知识开发你的查询，使用命令行工具(我个人最喜欢的:)。
#1
52
PoorMansTSqlFormatter is a free and open-source online beautifier, with offline SSMS Add-In, command-line beautifier tool, and Notepad++ plugin.
PoorMansTSqlFormatter是一个免费的、开源的在线美化工具，具有离线SSMS插件、命令行美化工具和记事本+插件。
The project aims to format any T-SQL (2000 or later) script, no matter the length or complexity.
该项目旨在格式化任何T-SQL(2000或更高)脚本，无论其长度或复杂性如何。
Hope this helps!
希望这可以帮助!
#2
17
T-SQL Tidy is a very good online SQL formatter/beautifier.
T-SQL Tidy是非常好的在线SQL格式化程序/美化器。
It has a lot of formatting options. Though it's targeted to T-SQL, it should work with most SQL dialects.
它有很多格式化选项。尽管它的目标是T-SQL，但它应该适用于大多数SQL方言。
#3
6
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.
有一个免费的在线即时SQL格式化程序。该网站还出售其他一些版本(比如Visual Studio的插件)，但在线版本是免费的。
#4
2
red Jul 22 '10 at 15:13 @Christopherous 5000
red Jul 22 '10 at 15:13 @Christopherous 5000。
I was looking for the same in notepad++ and found a link that gives an idea of how to create your own formatting with macros: http://peoplesoft.wikidot.com/formatting-sql-in-notepad. Seems like it would work, but I'm going to use one of the SSMS Add-ins above. (Less work) Thanks!
我在notepad++中寻找相同的内容，并找到了一个链接，该链接提供了如何用宏创建自己的格式的方法:http://peoplesoft.wikidot.com/formatting-sql-in-notepad。看起来是可行的，但我将使用上面的ssm插件之一。(不工作)谢谢!
#5
1
I've always been a fan of navicat - http://www.navicat.com
我一直是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
他们的lite版本是免费的，但它仍然附带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.
作为额外的奖励，偶尔你会发现一些中式英语藏在奇怪的地方。
#6
0
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:)).
Sequel Pro如果使用的是OS X，那么你需要的是什么，那么就用你的知识开发你的查询，使用命令行工具(我个人最喜欢的:)。