creation date

In Informix 7.31 is there a way to know the creation date of a table ? I think I have to look at the sysmaster database, but in what way ? Thanks for your help

Davide Locatelli wrote: > > In Informix 7.31 is there a way to know the creation date of a table ? > I think I have to look at the sysmaster database, but in what way ? > > Thanks for your help You can simply query the column created in systables, e.g. SELECT created FROM systables WHERE tabname = "mytable". But if You alter a table, then created will show the date of the alter and not the date of the orginal creation. Wolfgang

>Subject: creation date >From: "Davide Locatelli" davide.locatelli@rulmeca.it >Date: 02.05.00 11:07 W. Europe Daylight Time >Message-id: <8em5tj$1qnc$1@stargate1.inet.it> > >In Informix 7.31 is there a way to know the creation date of a table ? >I think I have to look at the sysmaster database, but in what way ? > >Thanks for your help > > > > > > > > select * from systables where tabname="mytable" Nona