Subject | system tables - second attempt. |
---|---|
Author | Mitchell Peek |
Post date | 2005-04-15T15:35:28Z |
Either my question is so basic and stupid that no one bothered to answer
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 double quotes. Am I just overlooking it?
Thanks,
Mitchell Peek
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 double quotes. Am I just overlooking it?
Thanks,
Mitchell Peek