Re: table creation timestamp

Bob Baskett writes: > >i 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 could get the creation *date* (but not time) by SELECT created FROM systables WHERE tabname = "<tablename>"; Thiswill not reflect any table alterations though. There is nothing that tracks the last "update" (we'd be forever modifying it!). There is a verion column in systables that get sincremented when an ALTER TABLE is performed, but it is not a timestamp. The timestamp you see in tbcheck is stored in the tblspace tblspace, and is not available to users via any method other than tbcheck. Dave -- Disclaimer: These opinions are not those of Informix Software, Inc. ************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney