Wrox Home  
Search P2P Archive for: Go

  Return to Index  

sql_language thread: Detecting the last change datetime for a table


Message #1 by "Mark Powell" <mpowell@a...> on Tue, 6 Feb 2001 16:09:04 -0000
--0-1161041831-981549556=:54329
Content-Type: text/plain; charset=us-ascii


Log files?


  

  Mark Powell <MPowell@a...> wrote: 
Imar,
Thanks for the reply. As I say in my original message, I realise that a 
trigger and an external table is an option, but would rather use any table 
properties that exist if possible. Is there no way to know when the table 
was updated without the use of a timestamp column (large overhead as each 
record would have a timestamp whereas I only want the timestamp of the last 
change + as you say deletion would cause problems), or external 
tables/triggers? 
Regards,
Mark.


  Return to Index