Fetch the modified date of table in SAP HANA

SAP HANASAPSAP Basis

 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.


raja
Published on 14-Dec-2017 10:23:15
Advertisements