Re: [SQL] case sensitivity for tables, columns, and constraint names

2007-12-11 Thread Richard Huxton
Ertel, Steve wrote: I see that I can create a table with a mixed case name as long as the name is wrapped in quotes. Is there a setting to allow upper case and mixed case names for database tables, fields, etc, without having to wrap each in quotes? No, SQL defines identifiers as case-insensit

Re: [SQL] case sensitivity for tables, columns, and constraint names

2007-12-11 Thread Andrew Sullivan
On Tue, Dec 11, 2007 at 11:05:25AM -0600, Ertel, Steve wrote: > is wrapped in quotes. Is there a setting to allow upper case and mixed > case names for database tables, fields, etc, without having to wrap each > in quotes? No, sorry. The always-one-case rule for unquoted identifiers is ANSI con

Re: [SQL] case sensitivity for tables, columns, and constraint names

2007-12-11 Thread A. Kretschmer
am Tue, dem 11.12.2007, um 11:05:25 -0600 mailte Ertel, Steve folgendes: >  > I see that I can create a table with a mixed case name as long as the name is > wrapped in quotes. Is there a setting to allow upper case and mixed case > names > for database tables, fields, etc, without having to

[SQL] case sensitivity for tables, columns, and constraint names

2007-12-11 Thread Ertel, Steve
I see that I can create a table with a mixed case name as long as the name is wrapped in quotes. Is there a setting to allow upper case and mixed case names for database tables, fields, etc, without having to wrap each in quotes? Thanks, SteveE