Skip to Content
0

How to fetch last accessed datetime for a HANA Table function

May 08 at 08:17 AM

43

avatar image

Hi,

I want to fetch information such as (last accessed datetime) for HANA table function, but I couldn't find the system view which gives this information. Although I found something similar for HANA Tables using the below query :

SELECT * from SYS.M_TABLE_STATISTICS where table_name = 'Table1' and schema_name = 'Schema1'

which has columns such as LAST_MODIFY_TIME and LAST_SELECT_TIME.

Can someone please suggest/point which system table should be used for table function.

Quick reply will be highly appreciated.

Regards,

Maninder

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers