Checking dependent object of a table in SAP HANA


This can be checked via SQL query on view in HANA system. Try run the below query −

SELECT "DEPENDENT_OBJECT_NAME" from "SYS"."OBJECT_DEPENDENCIES" WHERE "BASE_SCHEMA_NAME"
 = 'AF_HANA' AND "BASE_OBJECT_NAME" = 'STORE' AND "DEPENDENT_OBJECT_NAME" Not like
'%hier%';

Updated on: 13-Mar-2020

553 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements