Hi Set,

> 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.

I think they mean outside triggers there. Because the 5.5 Data
Definition Guide also says:

"Use DROP TABLE to remove a table's data, metadata, and indexes from
a database. It also drops any triggers that are based on the table."

Greetings,
Paul Vinkenoog