blocks|key|979102|text|Sequel+Pro如果使用的是OS，只需计算出您需要什么，然后使用您的知识开发您的查询，并使用命令行工具(我个人最喜欢的：)。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|979103|entityMap|0|LINK|mutability|MUTABLE|url|http://www.sequelpro.com/^0|0|A|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

<a href="http://www.sequelpro.com/" rel="nofollow noreferrer">Sequel Pro</a> 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:)).

blocks|key|979179|text|我一直都是navicat+-+http://www.navicat.com的粉丝|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|979180|他们的精简版是免费的，但它仍然带有sql美化器-+http://www.navicat.com/en/products/navicat_premium/premium_feature.html|979181|作为一个额外的好处，你偶尔会发现一些中国式英语隐藏在奇怪的地方。|979182|entityMap|0|LINK|mutability|MUTABLE|url|http://www.navicat.com/|1|http://www.navicat.com/en/products/navicat_premium/premium_feature.html^0|F|M|0|0|P|1Z|1|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@$A|S|B|T|1|U]]|C|$]]|$1|D|3|E|5|6|7|V|8|@]|9|@$A|W|B|X|1|Y]]|C|$]]|$1|F|3|G|5|6|7|Z|8|@]|9|@]|C|$]]|$1|H|3|-4|5|6|7|10|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]|P|$5|K|L|M|C|$N|Q]]]]

I've always been a fan of navicat - <a href="http://www.navicat.com" rel="nofollow noreferrer">http://www.navicat.com</a>

Their lite version is free, but it still comes with the sql beautifier - <a href="http://www.navicat.com/en/products/navicat_premium/premium_feature.html" rel="nofollow noreferrer">http://www.navicat.com/en/products/navicat_premium/premium_feature.html</a>

As an added bonus occasionally you'll find some chinglish hiding in odd places.

blocks|key|979228|text|T-SQL+Tidy是一个非常好的在线SQL格式化/美化工具。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|979229|它有很多格式选项。虽然它是针对T-SQL的，但它应该可以与大多数SQL方言一起工作。|979230|entityMap|0|LINK|mutability|MUTABLE|url|http://www.tsqltidy.com/^0|0|A|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

<a href="http://www.tsqltidy.com/" rel="noreferrer">T-SQL Tidy</a> 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.

blocks|key|979295|text|有一个免费的在线Instant+SQL+Formatter。该网站还出售一些其他版本(例如，Visual+Studio的插件)，但在线版本是免费的。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|979296|entityMap|0|LINK|mutability|MUTABLE|url|http://www.dpriver.com/pp/sqlformat.htm^0|8|L|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

There is a free online <a href="http://www.dpriver.com/pp/sqlformat.htm" rel="noreferrer">Instant SQL Formatter</a>. The site also sells some other versions (add-in for Visual Studio, for example), but the online version is free.

blocks|key|1193730|text|PoorMansTSqlFormatter是一个免费和开源的在线美容师，具有离线SSMS插件，命令行美容师工具和Notepad%2B%2B插件。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1193731|该项目旨在格式化任何T-SQL+(2000或更高版本)脚本，无论其长度或复杂性如何。|1193732|希望这能有所帮助！|1193733|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/TaoK/PoorMansTSqlFormatter^0|0|L|0|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|C|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]]]

<a href="https://github.com/TaoK/PoorMansTSqlFormatter" rel="noreferrer">PoorMansTSqlFormatter</a> is a free and open-source online beautifier, with offline SSMS Add-In, command-line beautifier tool, and Notepad++ plugin.

The project aims to format any T-SQL (2000 or later) script, no matter the length or complexity. 

Hope this helps!

blocks|key|979388|text|red+Jul+22+'10+15:13+@Christopherous+5000|type|unstyled|depth|inlineStyleRanges|entityRanges|data|979389|我在notepad%2B%2B中寻找了同样的东西，并找到了一个链接，它提供了如何用宏创建自己的格式的想法：http://peoplesoft.wikidot.com/formatting-sql-in-notepad。它似乎可以工作，但我将使用上面的SSMS插件之一。(更少的工作)谢谢！|offset|length|979390|entityMap|0|LINK|mutability|MUTABLE|url|http://peoplesoft.wikidot.com/formatting-sql-in-notepad^0|0|1D|1J|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

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: <a href="http://peoplesoft.wikidot.com/formatting-sql-in-notepad" rel="nofollow">http://peoplesoft.wikidot.com/formatting-sql-in-notepad</a>. Seems like it would work, but I'm going to use one of the SSMS Add-ins above. (Less work) Thanks!

I want to beautify the SQL Queries I write. 

What free tools exist that allow for SQL query formatting?

What Free SQL Formatting Tools exist?

命令行工具

Visual Studio

我想美化我编写的SQL查询。有哪些免费的工具可以进行SQL查询格式化？

问有哪些免费的SQL格式化工具？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问有哪些免费的SQL格式化工具？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问有哪些免费的SQL格式化工具？
EN