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 all the list of fields for a table in SAP HANA

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


1 Answer
SAP ABAP Expert

You can check this detail using a SQL query in HANA. You have to pass schema name in Where condition. Try running below SQL query:

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

Advertisements

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