Checked for stored procedures?
Checked for other tables that depend on this as a foreign key?
(You might have to drop the constraint temporarily if so...)

Nige.

> -----Original Message-----
> From: ben_ata [mailto:spam_eater@...]
> Sent: Wednesday, 24 November 2004 10:56 AM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Cannot drop table...
>
>
>
>
> Hello when I try to drop a test table, I get the following
> error message:
>
> -cannot delete
> -TABLE PERSON
> -there are 1 dependencies
>
> 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?
>
> Thanks in advance
> Thomas
>
>
>
>
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> $9.95 domain names from Yahoo!. Register anything.
> http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/67folB/TM
> --------------------------------------------------------------
> ------~->
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>