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

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