Does capitalization in SQL matter?

Is SQL Data case sensitive?

SQL Server is, by default case insensitive; however, it is possible to create a case sensitive SQL Server database and even to make specific table columns case sensitive. The way to determine a database or database object is by checking its “COLLATION” property and look for “CI” or “CS” in the result.

Does uppercase and lowercase matter in SQL?

The SQL standard requires implementations to ignore case in identifiers (it folds them to upper case). So your code should not depend on case differences in identifiers, and the conventional way to do that is to make identifiers all_lower_case .

Is SQL like case sensitive?

LIKE performs case-insensitive substring matches if the collation for the expression and pattern is case-insensitive.