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

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

• 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
• Checking Compression ratio of a table in SAP HANA
• Changing storage type of table in SAP HANA database
• Checking dependent object of a table in SAP HANA
• Fetch unique records from table in SAP ABAP
• Inserting data in table in SAP HANA
• MySQL query to fetch the latest date from a table with date records
• Deleting from temporary table in SAP HANA
• Maximum Table name length in SAP HANA