Skip to Content

How to fetch last accessed datetime for a HANA Table function

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers