Please note, this is a STATIC archive of website www.tutorialspoint.com from 11 May 2019, cach3.com does not collect or store any user information, there is no "phishing" involved.
Tutorialspoint

Checking dependent object of a table in SAP HANA

In SAP HANA database, we want to see the list of dependent objects of a table. Can this be checked using a SQL query in HANA Studio?


1 Answer
SAP ABAP Expert

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%';

Advertisements

We use cookies to provide and improve our services. By using our site, you consent to our Cookies Policy.