Sandy,

try the following statement to get a list of tables and fields for a
specific used domain.

select rdb$relation_name, rdb$field_name from rdb$relation_fields
where rdb$field_source = 'YOURDOMAIN' order by rdb$relation_name

Best Regards,
Thomas Steinmaurer
IB LogManager 2.0 - The Logging Tool for Interbase/Firebird
http://www.iblogmanager.com

--- In ib-support@y..., "sd_webpage" <sd_webpage@y...> wrote:
> Hi All,
>
> I am need of some help here ...
>
>
> The Application IBEXPERT allows you to select a domain (DOM_CLIENT)
> and by clicking on a certain tab (USED BY) it will display a list
of
> tables that the domain is used in (along with a the fields in each
> table that uses it).
>
> What I am wondering is:
>
> Does anyone know of the SQL that will allow me to return the
results
> as above?
>
> Thanks in advance
>
> Sandy Donaldson