Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    DE
    Posts
    6

    Unanswered: last change time/timestamp of table

    hello,

    i need to know the SQL statement to get the last change/modification time or timestamp of a table. is there some internal change tracker or something else?

    thank you for posts!

    greets
    P

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: last change time/timestamp of table

    Not I am aware of ...

    You will have to use a column, say last_updated in the table to know when a row was updated ..

    If you are interested to know only the last update time at the table level, you can use a trigger to update a row in another table to identify the last modified timestamp

    cheers
    Sathyaram

    Originally posted by poekel
    hello,

    i need to know the SQL statement to get the last change/modification time or timestamp of a table. is there some internal change tracker or something else?

    thank you for posts!

    greets
    P
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •