What are the SQL formatting patterns? Do you have any tools that can do that?

Question

What are the SQL formatting patterns? Do you have any tools that can do that?

Navigation

#1 by (1 votes)

1

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

sql

asked by anonymous 25.03.2014 / 17:28

1 answer

What would be an alternative to the "obsolete" showDialog function? How to standardize the formatting of javascript and php codes?

score 1 · Answer 1

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

link

This tool allows you to format SQL's of several SGDB's, so that they become more "cute".

Speaking of pattern, I do not think there is one as long as it works and is readable. The formatting may vary depending on the case, and what is considered to be readable . In many cases the formatting of a SQL gives focus on some parts, but leaves other parts more compact ... readability is a human factor, so this justifies my opinion of not having a pattern.