- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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.
- Related Articles
- Getting statistics details of SAP HANA system
- Getting License details, hardware key in SAP HANA
- Fetch the modified date of table in SAP HANA
- Maintaining topology details of SAP HANA
- SAP HANA view maintaining license details
- Details maintained under Name server in SAP HANA
- Checking authoring schema job details in SAP HANA
- Viewing license details on SAP HANA system
- Checking various details in SAP HANA in multitenant environment
- Details available under M_LICENSES System View in SAP HANA
- Disk utilization and configuration details view in SAP HANA
- Details available under M_BLOCKED_TRANSACTIONS System View in SAP HANA
- Details available under M_VOLUME_IO_TOTAL_STATISTICS System View in SAP HANA
- Creating a new table in SAP HANA
- Getting age of tracefiles in SAP HANA database

Advertisements