Syntax error Checking dependent object of a table in SAP HANA

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: 2020-03-13T07:38:59+05:30

988 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements