> > > > UPDATE RDB$PROCEDURES SET RDB$PROCEDURE_SOURCE = NULL
> > > >
> > >
> > > Can i reverser it at any moment?
> >
> > No. Of course not. Once deleted, you cannot get the source back.
>
> If someone will'nt write own reblrer ;))) Martijn, I have no need
> for it in my practice but my sclerosis whishpers something
> unintelligible about - NULL or ''? Seems there were problems with NULL
> but sclerosis can swindle me ;) And one more his whisper - don't
> forget to add Where RDB$TRIGGER_NAME Not Starting 'RDB$' when make the
> same with RDB$TRIGGERS table, or some of system triggers will fire
> twice.

The issue with triggers is solved in Fb, I thought.

Nevertheless, Alexander might be right: use SET ... = '' in order
to avoid these problems.

With regards,

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