Fetch the modified date of table in SAP HANA

 I think if you would have done some easy research or gone through the available documentation, then you would have got the answer. The reason being you already know the partial answer (SQL example as you said).

In SAP HANA database, we have an analogous table “SYS.M_TABLE_STATISTICS”. 

Just query the table for a table on the basis of last modified date by ordering it. With the use of “M_TABLE_STATISTICS” system view is not transactional. When a DML statement is rolled back, count values in the view remain unchanged.

Updated on: 13-Feb-2020


Kickstart Your Career

Get certified by completing the course

Get Started