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.

Prabhas

Updated on 13-Feb-2020 11:44:58

• Related Questions & Answers
• Getting details when a table is modified in SAP HANA DB
• Fetch max date and other field from the same row of a table grouped by other fields in SAP HANA
• Fetch the count of a specific date in a MySQL table
• Manual compression of a table in SAP HANA
• Viewing table definition in SAP HANA
• SAP HANA Release/version with date
• Adding millisecond to date in SAP HANA
• Inserting data in table in SAP HANA
• Fetch unique records from table in SAP ABAP
• Changing storage type of table in SAP HANA database
• Checking dependent object of a table in SAP HANA
• Checking Compression ratio of a table in SAP HANA
• Create table SQL query in SAP HANA
• Default table type in SAP HANA database
• Creating column table in SAP HANA database