Are database table names case sensitive?

Is SQL case sensitive on names?

At the time of table creation, all columns are created with all lowercase names regardless of quoting. The column names in a select statement are not case sensitive even if quoted.

Are database usernames case sensitive?

MySQL compares data in a case-insensitive manner except for database, table and column names.

Is SQL database 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.

Which databases are case sensitive?

Database vendorPossible settingsMicrosoft AccessNot case-sensitiveIBM® DB2® and DB2 UDB components for Rational ProductsCase-sensitiveMicrosoft SQL ServerNot case-sensitive, Case-sensitiveOracleCase-sensitive