Re: schema dates

Mister Creosote (glynb@my-deja.com) wrote: : In article <88ed9k$n9k$1@news.xmission.com>, : a_blonde@mindless.com wrote: : > : > ---- you wrote: : > > Is there a way to find the date of a schema? I have two different : DB's : > > and they are both modified by outside users. In an attempt to : create a : > > historical DB I have unloaded the contents of one DB but when I use : the : > > current column settings with older unloaded data I get mismatches. : Any : > > help on this would be appreciated : > : > Only ls -l Dude. : > : > AB : I suspect what the original author is after is the date a specific : schema change was made to a specific table. We use Server Studio for : Informix (www.agsltd.com for downloadable eval) for many of our : database admin tasks. This shows the date each table was last : created/modified, so logic (?) dictates that this info must be in the : system tables somewhere. Login also dictates that I know not in which : system table this info resides. Oddly, logic was right. systables has a created column which has the date the table was created. sysdbspartn (in sysmaster) has a created column which shows the same thing, as do sysptnhdr, sysdbstab (for dbspace creation), sysdatabases, and systabinfo. HTH