Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Selected Reading
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.
Advertisements
