Mitchell Peek wrote:

> How can one determine, form the system tables, if a column name was
> declared with Dialect 3 syntax. in other words,
>
> Create table ATable (
> Quantity BigInt,
> "Quality" SmallInt )
>
> If I join rdb$relations, rdb$relation_fields, and rdb$fields, I can get
> almost everything I need, but not whether or not the field requires case
> sensitivity. Am I just overlooking it?

It's really simple. If field has any lower-case characters, then it's name is
case sensitive.

--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org