HANA Views Metadata : Creation Date
I am unable to find creation date of HANA Views. I looked at "SYS"."VIEW" as well as underlying base table "SYS"."RS_VIEWS_" but could not see a any date field. Where do I find information on when a HANA View was created and last modified?
(In case of HANA tables, information is available in column "CREATE_TIME" in view "SYS"."M_RS_TABLES" but not for views )
Raj Kumar Salla replied
SELECT * FROM _SYS_REPO.OBJECT_HISTORY
WHERE PACKAGE_ID = 'give_your_package_name'
AND OBJECT_NAME = 'give_your_view_name'
ORDER BY OBJECT_NAME, OBJECT_SUFFIX, VERSION_ID DESC;
Version-id 1 means newly created and the highest version id is the last modification one.