Subject | dialect 3 field names. |
---|---|
Author | Mitchell Peek |
Post date | 2005-04-14T16:51:01Z |
Perhaps a dumb question, certainly I am lazy, but, after looking through
the system tables and even a brief glance at Helen's wonderful book, I
haven't found the answer to....
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?
Thanks,
Mitchell Peek
the system tables and even a brief glance at Helen's wonderful book, I
haven't found the answer to....
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?
Thanks,
Mitchell Peek