Is there any difference between upper or lower case commands on SQLITE?

Asked May 04 '20 at 14:30

Active May 04 '20 at 14:30

Viewed 158 times

My question is if there's any performance difference between:

SELECT * FROM mytable

select * from mytable

yes, the whole question is about using reserved words in upper case for better legibility

asked May 04 '20 at 14:30

SidFerreira

1

No difference at all. Identifiers are case-insensitive in SQL. – Gordon Linoff May 04 '20 at 14:32
1

Same thing. (Back in the days, ANSI entry level SQL-92 required upper case keywords, but AFAIK no vendor had that restriction.) – jarlh May 04 '20 at 14:37

0 Answers0