Subject System tables: domain extraction
Author Cosmin Popa
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]