Is sql case insensitive ?

Answer 1

Yes

Answer 2

SQL keywords like SELECT, FROM, WHERE etc are case-insensitive but as per coding standards they are often written in CAPS. However in some setups table and column names are case-sensitive. MySQL has a configuration option to enable/disable it.

Answer 3

Yes and no. The actual SQL keywords (select, insert, where, between, alter...) are case-insensitive, but concerning the names of tables, fields and so on, they are case-insensitive in some RDBMSs (like Oracle) and case-sensitive in others (like MS SQL Server).