What are the SQL formatting standards? Do you have a tool that does this?

Question

I asked a similar question, but about javascript. But I deal a lot with SQL and Mysql codes. Is there a commonly accepted standard? Does anyone know of a tool that validates or modifies the code?

Answer 1

There is an online tool that I use to format SQL that is very confusing:

http://www.dpriver.com/pp/sqlformat.htm

This tool allows you to format SQL’s of various SGDB’s, so that they are more "cute".

Speaking of default, I don’t think there is one, as long as it works and is readable. Formatting may vary depending on the case, and what is considered be legible. In many cases the formatting of an SQL focuses on some parts, but leaves other parts more compact... readability is a human factor, so this justifies my opinion that there is no standard.