Subject Re: Field names upper case - true of firebird 2.0 also?
Author MichaelS
--- In firebird-support@yahoogroups.com, "Adam" <s3057043@y...> wrote:
> --- In firebird-support@yahoogroups.com, "MichaelS"
> <pitterpattern@y...> wrote:
> > I'm quite unused to firebird's apparent use of uppercase letters for
> > field names etc. Is this an acutal requirement, or is it optional?
>
> It is already optional.
>
> Try it in iSQL.
>
>
> CREATE TABLE TABLEA
> (
> FIELD1 INTEGER
> );
>
> COMMIT;
>
> select count(field1)
> from tablea;
>
> should work.

OK; but I can't *create* a table named tblItem, right? Would be
TBLITEM...at least the db management tools I've looked at all change
to uppercase. Yes it is good if firebird sees tblItem and knows it's
TBLITEM, but I'd rather have the table and field names themselves have
the flex.