Welcome to Software Development on Codidact!

Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.

Comments on Why is SQL usually written in CAPS?

Parent

Why is SQL usually written in CAPS?

+11

−0

Why are keywords in SQL usually written in capital letters? For example:

SELECT * FROM person WHERE mood = 'happy';

My understanding is that SQL is case insensitive, so the case doesn't actually make a difference?

sql

posted over 1 year ago

CC BY-SA 4.0

Iizuki‭

1557 reputation 30 32 211 33

Raw

Markdown

History

0 comment threads

Post

+14

−1

Though probably not the original reason, I would say it's still useful as it brings some kind of distinction between keywords and variables/columns, since SQL consists mostly of words with less punctuation than other programming languages. Consider:

SELECT name FROM animal LIMIT 10

which contains only spaces as non-alphanumeric characters.

animal.filter(limit=10)

containing a dot, a pair of parentheses and an equals sign as non alphanumeric characters.

Of course, there's syntax highlighting to show the distinction, but I think caps still add something.

posted over 1 year ago

CC BY-SA 4.0

luser‭

229 reputation 2 2 28 0

Copy Link

Raw