Subject | RE: info |
---|---|
Author | Leyne, Sean |
Post date | 2017-01-04T15:15:32Z |
> We want to create table- and fieldnames (Firebird 3) in camelcase.You can do that now, you can use whatever case you want.
> If weBy SQL standard Object names are case insensitive, so all objects are upper-cased.
> want to write a select statement we have to use quotes around a tablename.
> This is not userfriendly. Is there a way that we don't have to use the quotes
> in SQL-statements ?
There is an exception for objects created as "identifiers" which requires the use of double-quotes (another SQL standard) for all references to the Objects.
> We don't want to create our table- and fieldnames in lowercase orWhile the engine would return/display the object names in upper case, that does not stop you from using CamelCase in your SELECT statements, Triggers and SPs -- This is something that I do religiously, even after 20 years of using IB/FB.
> uppercase.
Sean