I found it, there was a dependancy on the fk field in the system tables
when I removed it from the trigger, I could drop the fk - weird

>From: "Nick Upson" <uebridger@...>
>Reply-To: ib-support@yahoogroups.com
>To: ib-support@yahoogroups.com
>Subject: Re: [ib-support] can anyone tell me why
>Date: Tue, 12 Feb 2002 11:11:01 +0000
>
>is there anything I could do to the system tables so that the
>Foreign key (and it's index) would disappear following a backup/restore.
>
>I'm actually trying to delete the FK column from the table
>but, of course, it won't go while the FK depends upon it.
>
>
> >From: "Claudio Valderrama C." <cvalde@...>
> >Reply-To: ib-support@yahoogroups.com
> >To: ib-support@yahoogroups.com
> >Subject: Re: [ib-support] can anyone tell me why
> >Date: Tue, 12 Feb 2002 02:50:30 -0400
> >
> >""Nick Upson"" <uebridger@...> wrote in message
> >news:F98SAkHQVIuMBZSsUg800011d82@......
> > >
> > > isql on unix
> > > IB4
> >
> >Call the museum. ;-)
> >
> > > >Does the engine die after that?
> > >
> > > the connection does, the engine is ok
> >
> >Usually, the engine dies, but if it didn't, then an internal error kills
> >the
> >connection anyway (or the DSQL layer didn't react properly). IB4 was
> >plagued
> >with those metadata bugs, although I found it robust for daily work.
> >Usually
> >I had to give up and recreate the table.
> >
> >C.
> >--
> >Claudio Valderrama C. - http://www.cvalde.com -
>http://www.firebirdSql.org
> >Independent developer
> >Owner of the Interbase� WebRing
> >
> >
> >
> >To unsubscribe from this group, send an email to:
> >ib-support-unsubscribe@egroups.com
> >
> >
> >
> >Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> >
> >
>
>
>_________________________________________________________________
>Chat with friends online, try MSN Messenger: http://messenger.msn.com
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>

_________________________________________________________________
Join the world�s largest e-mail service with MSN Hotmail.
http://www.hotmail.com