How to select column names from table by column domain name in Firebird?

Question

I need to select column names for a specific domain in Firebird.

eg. there is a domain COORDINATE

and I want to select all the column names in that domain.

Can this be done?

I am using Firebird 2.5

+3

Jason smith 11 Apr 17 at 8:59 am

1 answer

a_horse_with_no_name · Accepted Answer · 2017-04-11T09:11:44+0000

This is saved in rdb$relation_fields

:

select rdb$relation_name, 
       rdb$field_name,
from rdb$relation_fields
where rdb$field_source = 'COORDINATE';