FW: How to know which databases and tables created/deleted yesterday?

Posted in 2000

Dirk Moolman — Fri, 24 Nov 2000 08:31:30 +0200 — source: Informix-list mailing list archive (1991-1998)

Creation is easy. sysmaster:sysdatabases has a column that tells you when the database was created db:systables has a column that tells you when the table was created. Don't know about the deletion though. Dirk -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of DH Sent: Friday, November 24, 2000 4:57 AM To: informix-list@iiug.org Subject: How to know which databases and tables created/deleted yesterday? Hi all, I would like to have a daily report of the list of datatabases and tables were created or deleted yesterday. Is it possible to do that with IDS2000? Can I use Unix Shell script to query it and run it everynight automatically with Unix cron deamon? Thanks in advance for any advise. DH.