Is SQL syntax case sensitive?

Question

Is SQL case sensitive. I've used MySQL and SQL Server which both seem to be case in-sensitive. Is this always the case? Does the standard define case-sensitivity?

Answer 1

I've worked with DB2, T-SQL, and a few others and they always seem to be case-insensitive.

Answer 2

SQL Server has a setting that determines case sensitivity.

To determine: Run "SELECT SERVERPROPERTY("COLLATION").

If the response has a "CI" in it, that means Case Insensitive.

See https://www.webucator.com/how-to/how-check-case-sensitivity-sql-server.cfm