CODEWITHSUNDEEP
hana
Christian4145
Christian4145

Reputation: 543

How to figure out modify date of table in HANA

I need something like (on SQL-Server)

select name, modify_date 
from sys.tables

on HANA.

For those of you who don't know MS-SQL: I would like to query the timestamp of the last insert.

I would like to know the modify date for column and row tables.

Upvotes: 0

Views: 4070

Answers (1)

Daniel Sampson
Daniel Sampson

Reputation: 111

select * FROM SYS.M_TABLE_STATISTICS

or more specifically:

select "TABLE_NAME", "LAST_MODIFY_TIME" FROM SYS.M_TABLE_STATISTICS order by "LAST_MODIFY_TIME" desc

Upvotes: 2

Related Questions