Subject | Re: Field names upper case - true of firebird 2.0 also? |
---|---|
Author | Adam |
Post date | 2005-05-09T05:01:19Z |
>I am a bit confused by your questions.
> 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.
What version of Firebird are you running, the following will work on
1.5.2. The management tools probably have some historic reason for
doing it that way.
create table tblitem
(
id integer
);
commit;
select count(*) from TbLIteM;
select count(*) from tblitem;
select count(*) from TBLITEM;