Re: Last update/insert/delete on a table?

From: Steve Fawcett <sfawcett_at_dircon.co.uk>
Date: 1998/05/28
Message-ID: <356db154.0@newsread1.dircon.co.uk>#1/1

A simple way to check stuff like this is apply a database trigger that is fire on before insert/update and delete you could then put audit information into a second table.

Steve

Peter Chan wrote in message <356B0965.5B64_at_nortel.ca>...
>I was wondering if there is a way to find out the date and time of when
>a table was last updated/inserted/deleted on.
>
>Thanks a bunch.
>
>--
>====================================================================
>PETER CHAN, Northern Telecom
>PHONE: (613) 763-9096 FAX: (613) 763-4408 EMAIL: chanp_at_nortel.ca
>====================================================================
Received on Thu May 28 1998 - 00:00:00 CDT