Re: last update to a table

Or have an audit table that keeps timestamps of all changes.

Build the audit table and create a trigger to populate it on any insert, update or delete

This will save you altering the table you are looking at, if you don't want to change the table structure

Nick Received on Fri Feb 16 2001 - 04:46:27 CST