Datetime of Altered Table

Hi, I want to get the date and time when the table was last altered. ALso is it possible to know when was the last insert/select/delete/update was fired on the table. Bye.

The column created in systables is the last time an alter table was run on that table. The only way of determinine when the last activity (excluding select) is to trawl through the logs with onlog, assuming you have sufficient logs to trawl through and you have not done your own recording of insert/delete/update. If you have TBLSPACE_STATS on you can determine how much activity has taken place on the table since the stats were last reset. MW > -----Original Message----- > From: forum.subscriber@iiug.org > [mailto:forum.subscriber@iiug.org] On Behalf Of PARAMESHWAR.... > Sent: Monday, 29 August 2005 8:40 p.m. > To: ids@iiug.org > Subject: Datetime of Altered Table [5672] > > Hi, > I want to get the date and time when the table was last > altered. ALso is it possible to know when was the last > insert/select/delete/update was fired on the table. > > > > Bye. > > >