How can i get the modification time of a table?

Posted in 2000

Glup — Wed, 13 Sep 2000 10:26:14 +0200 — source: Informix-list mailing list archive (1991-1998)

I need get the time when a table was modified. Can I get it from a SQL Query? Thanks.

↪ replying to Glup

Christophe MAUMONT — Wed, 13 Sep 2000 12:28:26 +0200 — source: Informix-list mailing list archive (1991-1998)

Glup <glup@glup.es> a 'crit dans le message : 39bf3ada$1@news... > I need get the time when a table was modified. > Can I get it from a SQL Query? > > Thanks. > You should look at the triggers.

↪ replying to Glup

Robert Stuart — Wed, 13 Sep 2000 14:04:16 +0100 — source: Informix-list mailing list archive (1991-1998)

Try select * from systables where systables.tabname = "some_table_name"; ; some_table_name is your table name, and must be lower case It'll give you the created date, if not the time. "Glup" <glup@glup.es> wrote in message news:39bf3ada$1@news... > I need get the time when a table was modified. > Can I get it from a SQL Query? > > Thanks. > >