How to find out when a table was updated last?
843854May 6 2003 — edited May 6 2003This is not a JDBC question in particular. It is a database question. But of course I'll be using JDBC for it...
Do most major databases allow you to find out the last time that anything in the table was updated? If so, how?
Also, is it possible to get the database to tell you all the tables that a query depends on? (including those tables referenced by any queries referenced by the query?).
Or if not, if it is possible at least to find out what tables and queries a specific query uses?