--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> >
> >How do I find out which dependency that is?
> >
> >I did a SHOW TABLE PERSON; but this didn't reveal anything (simply
> >showed the table structure). I had a trigger attached to that

table,

> >but I have already dropped that as well.
> >
> >What am I missing here?
>
> 1. Use SHOW TRIGGERS to find all of the trigger dependences.
> 2. Use SHOW PROCEDURES to look for table references.
> 3. SHOW TABLES will show the FK and CHECK constraints.

I finally found it: it was a VIEW on the table. I was constantly
looking for FK references which weren't there :)

> The lesson is: don't fiddle about with dependencies when users are
> doing stuff.

I was the only one on the database...

Thanks for your help.

Best regards
Thomas