Do SQL clauses always have to be entirely capitalized?


#1

Question

When writing SQL queries, do the commands, like SELECT and FROM have to be all capital letters?

Answer

No, SQLite, which Codecademy uses, is case-insensitive when it comes to clauses like SELECT and FROM which can be cased in any way. This is different from other programming languages such as Python where casing is quite important.

Example

/* Both of the following queries will return the same result. */
SELECT * FROM table;

select * from table;