Subject | Determining internal storage codes |
---|---|
Author | Kevin Stanton |
Post date | 2003-08-03T19:01:53Z |
Greetings,
I have the sql statement to retrieve the internal storage code :
select r.rdb$field_name, f.rdb$field_type
from rdb$fields f, rdb$relation_fields r
where r.rdb$relation_name = 'A_TABLE_NAME' and
r.rdb$field_source = f.rdb$field_name
But I can't seem to find what the f.rdb$field_type actually is.
I know I found it somewhere (a chart) in the docs a long time ago, but can't
seem to locate it now (and am going slightly crazy).
Can anyone point me in the right direction.
Thanks a bunch!
Kevin
I have the sql statement to retrieve the internal storage code :
select r.rdb$field_name, f.rdb$field_type
from rdb$fields f, rdb$relation_fields r
where r.rdb$relation_name = 'A_TABLE_NAME' and
r.rdb$field_source = f.rdb$field_name
But I can't seem to find what the f.rdb$field_type actually is.
I know I found it somewhere (a chart) in the docs a long time ago, but can't
seem to locate it now (and am going slightly crazy).
Can anyone point me in the right direction.
Thanks a bunch!
Kevin