Script to check SQL Case Sensitivity

You can execute below script to check whether SQL Server is case sensitive or not

SELECT
case when 'a' <> 'A' 
then 'Case-Sensitive' 
else 'case-insensitive' end  AS 'Case Sensitivity'

1 thought on “Script to check SQL Case Sensitivity”