Subject Re: [firebird-support] system tables - second attempt.
Author Martijn Tonies
> >> which brings the question how do you tell between a column defined as
> >> "SOMEFIELD" and a column defined as SOMEFIELD?
> MT> Try creating such a table and you'll know :-)
> good idea. :-)
> It appears that if you delimit an all-uppercase identifier the engine
> behaves as if you didn't, i.e. you can refer to it in lower or mixed
> case without quotes. I don't know whether that's documented behaviour
> or not; I didn't know it for sure.

As far as I know, it is. All uppercase equals no quotes.

Unless you've used a keyword, of course.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions