If someone created a query for example

SELECT * FROM TMP_Items

Would this be the same?

SELECT * FROM TMP_ITEMS

Similar would these to yeild different results?

SELECT items from TMP_ITEMS

and

SELECT Items from TMP_ITEMS

Depending on the OS and the DB server, table names and column names may be case sensitive.

Usually, SQL is not case sensitive. So basically, the queries are just the same.

Thanks.

Originally Posted by robert1971

Usually, SQL is not case sensitive. So basically, the queries are just the same.

Thanks.

Not quite, commands and string literals are NOT case sensitive, table names and column names case sensitivity will depend on the Operating System the DB server is running on.

Any DB server running on Windows will be case insensitive while DB servers running on Unix/Linux will be case sensitive.