ACTION-129 Case sensitivity of identifiers

For the most part, databases use case insensitive identifiers except where the identifier is
enclosed in double quotes.  In that case the identifier is treated "as is".  This is, as we discuissed
last week what the SQL Standard says.

However for SQLSERVER I found that:
*If your database is created with a Case Sensitive collation then all object names will be Case Sensitive.*

Thus, it may be safest to say "database identifiers must follow the conventions dictated by the underlying database"
-- 
All the best, Ashok

Received on Tuesday, 17 May 2011 16:00:47 UTC