Getting details when a table is modified in SAP HANA DB

You can query SYS.M_TABLE_STATISTICS providing name of table and LAST MODIFY DATE. Here is the sample SQL query.

SELECT "ABC", "LAST_MODIFY_TIME"  
FROMSYS.M_TABLE_STATISTICS
ORDER BY “LAST_MODIFY_TIME" DESC

In above command, you need to replace “ABC” by your table name.

Rama Giri

Updated on: 05-Dec-2019

1K+ Views

Kickstart Your Career

Get certified by completing the course

Get Started