Writing the SQL-language

Writing SQL keywords and element names is not case sensitive. This means that the keywords and the names of schemas, tables and columns may be written in upper or lower case or as mixed case.

Thus, the query

select name, Address from customer

bears the same meaning as  the query

SELECT NAME, ADDRESS from Customer

However, referencing the data in the database is case sensitive. Thus, the query

select address from customer where name like 'Charlie%'

will not give the same result as the query

select address from customer where name like 'CHARLIE%'

There are no rules of how to use white space and line breaks in SQL. However, their proper uses improves the readability of SQL-expressions.