Hi How can I return the date a DB was last updated? In MS (spit) SQL it can be done with SELECT TOP 1 name, modify_date, type_desc FROM sy.sobjects ORDER BY modify_date DESC I can see that SQL Anywhere has SysObjects and Type but nothing for the last date modified asked 03 Jan '19, 13:02 gchq |
This FAQ may help. answered 03 Jan '19, 14:04 Mark Culp Mark Thank you for responding. I believe that FAQ is to query a specific table. I am attempting to query the DB to see which table was last updated and the date
(03 Jan '19, 14:12)
gchq
Replies hidden
AFAIK There is no one piece of information that tell you when the database as a whole was last modified but the FAQ is saying that you could query the SYSTAB table and find the times when each of the tables were modified. For example, extract the timestamp of the last table that was modified and that will be the time that the database was last modified. checkpoint; select first last_modified_at from sys.systab order by last_modified_at desc; HTH
(03 Jan '19, 14:32)
Mark Culp
Just what I wanted - thank you so much :-)
(03 Jan '19, 18:20)
gchq
|