Is SQL syntax case sensitive

Question

Is there a case difference in SQL? I've tried MySQL and SQL Server, both of which don't appear to care about case. Is this the case all of the time? Is case-sensitivity defined in the standard?

Answer 1

The SQL keywords (SELECT, FROM, WHERE, etc.) are case-insensitive, yet they are frequently expressed in all capitals. Table and column names are case-sensitive in some settings. MySQL provides a setting that allows you to enable or disable it. On Linux MySQL, case-sensitive table and column names are usually the default, while case-insensitive used to be the default on Windows, but the installer now asks about this during setup. It is a function of the database's collation setting in MSSQL.

If you need to know more about MS SQL, it is recommended to go for the SQL Certification Course today.