table creation date?

dnix · #1 (**permalink**) 09-28-03, 09:42

Does informix keep track (somewhere) of when a table is created, like a time stamp for auditing,etc...?

lloydnwo · #2 (**permalink**) 09-28-03, 23:34

Quote:

Originally posted by dnix
Does informix keep track (somewhere) of when a table is created, like a time stamp for auditing,etc...?

Hi there,

Yes informix keeps track of all tables created in sysmaster database.
You can run the below query
select * from systables where tabid>99

Regards,

lloyd

GoldenBoy · #3 (**permalink**) 09-29-03, 08:03

thanks for the info!

Internet Services

Web Development

Digital Marketing

Consumer Tech