Paul R. Gardner wrote:

>
> I have a database with roughly 100 tables. I want to add a TIMESTAMP
> field called LASTUPDATED into each table. Next, I'll have a Trigger
> Before Update/Insert that says:
>
> LastUpdated = current_timestamp;
>
> Is there any way to do this without 100 different triggers? Some sort
> of trigger on a RDB$ table that runs each time?
>

Unfortunately no. I'd write a script to generate the ddl for the
triggers...

Regards,


Ann