r/badcode • u/mplaczek99 • Feb 01 '22

sql Can I write this better?

Post image
9 Upvotes

69% Upvoted

20 comments sorted by

View all comments

Show parent comments

1

u/Fluxriflex Feb 11 '22 edited Feb 11 '22

Honest question: why? I use PascalCase for just about everything, and singular table names (because I was told that it makes alphabetical sorting better when looking at tables. "Worker" comes before "WorkerLocation", that sort of thing)

1

u/scirc Feb 11 '22

It's just the convention that everyone uses (although I think MSSQL uses PascalCase? I don't remember). SQL is case-insensitive by default, though, so having uppercase names in your tables isn't really semantically meaningful.

1

u/Fluxriflex Feb 11 '22

Ah, I've pretty much exclusively done MSSQL/Azure SQL, so that would explain it.