Re: table creation timestamp

>From: uunet!hermes1.sps.mot.com!inf_bb (informix users bb) >Date: Thu, 12 Nov 92 10:33:38 MST >Subject: table creation timestamp >X-Informix-List-Id: <list.1594> > >is there a way that the creation timestamp of a table can be obtained. >tbcheck -pt db:tab displays it, but i want to get this info non- >interactively and without having to wait for tbcheck to finish. also, >does informix stores the last update, last alter timestamp anywhere. You've changed id's -- inf_bb isn't who I normally answer to. Systables.Created tells you the day (but not the time) when the table was last altered. As far as I know, there is nowhere where the last update time is stored. And the last alter timestamp is only available in the data handled by tbcheck, which is not accessible except via tbcheck. Yours negatively, Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>