Subject Re: [ib-support] Unwanted Domains
Author Ann W. Harrison
At 09:29 PM 7/12/2001 +0000, Todd Brasseur wrote:
>Is there a quick way of getting rid of all domains in a database that
>aren't used by anything?

delete from rdb$fields f where not exists
(select 1 from rdb$relation_fields rfr
where rfr.rdb$field_source = f.rdb$field_name);

Regards,

Ann
www.ibphoenix.com
We have answers