--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> At 05:22 AM 9/05/2005 +0000, you wrote:
> > >
> > > select count(*) from TbLIteM;
> > > select count(*) from tblitem;
> > > select count(*) from TBLITEM;
> >
> >Hi Adam - well, if firebird can do that, then I'm really happy. It
> >seems that all three of the main tools I'm evaluating for use with
> >firebird (1.5.2) force uppercase...DB Workbench and DB Visualiser do
> >anyways, I'm now having problems with SQL Hammer and can't test that
> >right now.
>
> OK, I think what you are encountering is query-builder tools that

offer you

> a column list, correct?
>
> These tools build these selection lists by querying the system

tables. All

> of the metadata of a Firebird database are stored and maintained in

these

> tables - so, of course, when one queries
>
> select rdb$relation_name from rdb$relations
> where rdb$relation_name not starting with 'RDB$'
>
> one gets a list of table names in upper case - because they are

stored as

> uppercase strings!!
>
> Incidentally, running the above query as this:
>
> select rdb$relation_name from rdb$relations
> where rdb$relation_name not starting with 'rdb$'
>
> is going to yield all of the names of the system tables as well,

since all

> of the system tables' names are ALSO stored in uppercase. :-)
>
>
> ./heLen

No actually I'm trying to create tables and fields from scratch,
albeit using either db workbench or db visualizer. So far at least I
have no luck with lower case attempts. Haven't tried much via command
line yet, and dont' want to be be reduced to that....