My Firebird documentation says that DROP TABLE will fail if the table is
referenced in an SQL expression, a view, intergrity constraint or stored
procedure. The command drops the tables data, metadata, indexes and
triggers that reference the table. However, I've also got Ib 5.5
documentation saying that deleting a table fails if it is used in a view,
trigger or computed column, so this could well be a change introduced in Ib
6.0 or Fb.

Set

At 11:15 13.06.2003 +0000, you wrote:

>if I try to drop a table that has a before_insert trigger, what should
>happen?
>
>I think I should get an error and the drop would fail but I've just had a
>case where the drop table suceeded and the trigger was silently dropped as
>well, is this correct? is this a change (I've jumped from IB4 to firebird
>1.0.2)