Difference between revisions of "Well Formed SQL Statements"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| + | [[Category:Conventions]] | ||
| + | [[Category:SQL]] | ||
== General == | == General == | ||
SQL statements can be read much easier, if they are well-formatted. | SQL statements can be read much easier, if they are well-formatted. | ||
Latest revision as of 15:50, 15 July 2010
General
SQL statements can be read much easier, if they are well-formatted.
Good formatting is achieved as follows:
- align the SQL keywords to the right
- make use of field and table aliases
- use only one field per line
- align operators to the right
- align values to the left