To understand a sentence about the case in SQL/DDL -queries?

No, I think the gentleman referred to using all lowercase identifiers, e.g. Table, column etc. Names. This should have no impact on the commands like CREATE TABLE etc. That you use Marc.

No, I think the gentleman referred to using all lowercase identifiers, e.g. Table, column etc. Names. This should have no impact on the commands like CREATE TABLE etc. That you use. Marc.

In PostgreSQL, an unquoted identifier is converted into lowercase: CREATE TABLE "MYTABLE" (id INT NOT NULL); CREATE TABLE "mytable" (id INT NOT NULL); INSERT INTO "MYTABLE" VALUES (1); INSERT INTO "mytable" VALUES (2); SELECT * FROM mytable; --- 2 SELECT * FROM MYTABLE; --- 2 Both queries will return 2, since they are issued against "mytable", not "MYTABLE". To return 1 (i. E.

Issue a query against "MYTABLE", not "mytable"), you need to quote it: SELECT * FROM "MYTABLE"; --- 1 CREATE TABLE etc. Are not identifiers, they are reserved words. You can use them in any case you like.

I have no idea why he said that. In SQL Server, at least, the case of an identifier doesn't matter. Maybe it does in other DBMS systems?

1 Some RDBMS are case-sensitive. MySQL MyISAM table names are case-sensitive if the underlying filesystem of the OS on which the server is running is case-sensitive. This is because there is a one-to-one mapping between the table name and the file that stores its contents on disk.

This can lead to the weird situation where MySQL table names are case-sensitive on Unix systems but not on Windows systems! – Ken Keenan Jul 29 '09 at 14:12 @Ken: Thank you for your comment! – Masi Jul 29 '09 at 14:35 Thanks, Ken, that clarifies it.

– John Saunders Jul 29 '09 at 15:27 1 Case sensitivity in MS SQL Server depends on collation. I have never worked with a database that had a case sensitive collation, but according to the documentation, the identifiers would be case sensitive if the collation for the database is case sensitive. Another example, in Oracle unquoted identifiers are forced to upper case, quoted identifiers are matched as is, and are case sensitive.

– Shannon Severance Jul 29 '09 at 17:29 1 Can you post where it says that in the documentation? I find it hard to believe identifiers case sensitivity changes based on collation. – John Saunders Jul 29 '09 at 17:38.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.