/sql-style

A style guide for SQL

sql-style

A style guide for SQL

Key/Reserverd words should be lower case and names should be upper case

Like this:

select FIELD from FILE where SOMETHING = OTHERTHING

Not this:

SELECT field FROM file WHERE something = otherthing

Never this:

Select Field From File Where Something = Otherthing

Include the “as” keyword when aliasing a variable or table name. Always use a full description for correlation names, not just a letter.

Like this:

select FIELD as ALIAS_NAME
from FILE as FILE_ALIAS

Not this:

select FIELD ALIAS_NAME
from FILE FILE_ALIAS

Never this:

select FIELD F
from TABLE T

Always include the JOIN type rather than relying on the default join.

Like this:

select FIELD 
from FILE1  
inner join FILE2

Not this:

select FIELD 
from FILE1  
join FILE2

Never this:

select FIELD
from FILE1, FILE2