Subject Re: double quotes
Author Adam
> Why do you create the table with double quotes in the first place????
>
> Thomas

It is an understandable reason. When your table names start to
describe relationships, multiple entity names may be included in the
table name. As spaces in table names are not practical, capitalising
the first letter of each word is nearly as useful (readability wise).

What would be useful is if the system tables stored a display name for
an object.

For example:

CREATE GENERATOR GEN_OneOfMyTablesID;

The RDB$GENERATORS.RDB$GENERATOR_NAME could still store
'GEN_ONEOFMYTABLESID', but some display name field could store
'GEN_OneOfMyTablesID'

This would allow existing applications to work without change, but
would provide the possibility for database explorer tools and client
connection components to display the name with better capitalisation.

The above example is a generator, but the same could be done for
tables, views, fields, stored procedures, parameters, triggers, etc.

Adam