- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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%';
- Related Articles
- Checking Compression ratio of a table in SAP HANA
- Checking object dependency in SAP HANA system
- Checking a table inside a schema in SAP HANA database
- Checking all the list of fields for a table in SAP HANA
- Checking topology of SAP HANA
- Checking performance of SAP HANA system
- Checking savepoint statistics of SAP HANA
- Checking version of SAP HANA system
- Checking System limits in SAP HANA
- Checking enforced license in SAP HANA
- Checking backup configuration in SAP HANA
- Checking status of Auto Documentation in SAP HANA
- Checking list of system schema in SAP HANA
- Checking configuration of XS service in SAP HANA
- Checking tables in a schema in SAP HANA database

Advertisements