Hi ng,

using FB2 RC2, but I don't think my problem is specific to that version.

In my DB I have a table HPQMAIN with some fields.
There's also a stored procedure sp_findDups in the DB, that queries
several fields in HPQMAIN and returns some result.

Now I want to drop both table and procedure, when my client program
requests it.

Tried to 'DROP TABLE HPQMAIN;' but received dependency error regarding
sp_findDups.
Tried to 'DROP PROCEDURE "sp_findDups";' but received dependency error
regarding HPQMAIN.

Is there something like 'DROP DEPENDENCY <somedep>'?

regards,

Thomas Besand