Subject | System tables: domain extraction |
---|---|
Author | Cosmin Popa |
Post date | 2002-07-17T16:12:44Z |
Does someone know how to extract the domains from an IB/Firebird database ?
if I issue this select
"select rdb$field_name, rdb$field_length, rdb$field_precision, rdb$field_scale, rdb$field_type
from rdb$fields
where rdb$system_flag = 0"
I obtain all the domains (including the auto-generated ones).
The only difference between the two groups of them (those explicitly generated and those implicitly) is the prefix 'RDB$' in the rdb$field_name column, but this criteria is too ambiguous.
Thanx.
[Non-text portions of this message have been removed]
if I issue this select
"select rdb$field_name, rdb$field_length, rdb$field_precision, rdb$field_scale, rdb$field_type
from rdb$fields
where rdb$system_flag = 0"
I obtain all the domains (including the auto-generated ones).
The only difference between the two groups of them (those explicitly generated and those implicitly) is the prefix 'RDB$' in the rdb$field_name column, but this criteria is too ambiguous.
Thanx.
[Non-text portions of this message have been removed]