Jonathan,

> > Right. Procedures are compiled. Sources may be destroyed, so -
> >recompilation isn't possible.
> >
> >
> Yes, but don't you agree that it doesn't make sense to destroy the
> sources? Obviously, any information in the system tables _can_ be
> destroyed, but if you do so, there's no garantee that the DB will
> operate correctly... I think it's the same for the source code of
> triggers and procedures.

It will operate correctly if you only destroy the source.

The engine itself uses the compiled BLR.

You can remove the source to keep your source code safe.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com