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.

raja
Published on 12-Dec-2017 11:30:54
Advertisements