I tried your statement:

After removing the domains I went to add a new column to a table (with
an existing domain). I got a 'connection lost to database error'.

So I reconnected and tried again and got the same error.

From INTERBASE.LOG -

CERTDATA (Client) Thu Jul 12 16:06:27 2001
C:\Program Files\Borland\INTRBASE\bin\ibserver.exe: terminated
abnormally (-1073741819)

So I tried to Backup Up the database and the backup failed.

So I copied back my original backup to get things back to normal. I
don't know exactly what went wrong. Your statement showed some 2140
domains that needed to be removed.

Todd Brasseur

Ann W. Harrison wrote:

> 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
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/>.