Subject Re: [firebird-support] Anyway to recover a dropped stored procedure?
Author Martijn Tonies
Hello Mike,

> I use Database Workbench to work on my Firebird 1.5 database
> I have been working most of the morning on a new stored procedure.
> As I was just finishing clean up work on this new stored procedure, I
> decide to delete 2 input parameters that i no longer needed, so I select
> the first parameter and click the delete parameter button, then select the
> second parameter and click the "Drop Procedure" button by accident as the
> two buttons are within an inch of each other.

I'm sorry to hear you clicked the wrong button, but they appear in different

> So is there anyway to retreive this new stored procedure that I just
> dropped?

Unless you have a backup or script, no there is not.

The upcoming Database Workbench 4 has a feature called "Secure object drop"
that can help you to avoid this problem.

With regards,

Martijn Tonies
Upscene Productions

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum: