|Subject||Re: [firebird-support] system tables - second attempt.|
> Either my question is so basic and stupid that no one bothered to answerdouble quotes. Am I just overlooking it?
> such an idiotic question, or, it is so complex that no one knows the
> answer, or it got lost and no one ever read it. I strongly suspect
> that it isn't the second possibility.
> Anyway, second try.
> I am accessing the system tables to build scripts to define auxillary
> tables, triggers etc. based on defined tables in several databases.
> How can one determine, from 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 column name requires
>Did you actually try it?
Any value uppercased in the system table, means that it doesn't
use quotes. And value lower, or mixed case means it uses quotes.
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL