Getting list of all the Views and their Metadata in SAPA HANA

[Former Member]

Hi Everyone,

I was wondering if someone could help me with the following:

1. How could I get a list of names of all the Views in my HANA system?

2. How to access all the metadata of each of these views?

Basically I want to display the information in a SAP UI5 tree or a table with all the view names along with the meta-data. So if there is a system table where all the information is maintained, I can query that or create a service to get the details in JSON format. Any help is greatly appreciated.

Thank you in advance.

[surya_prasad9]

use SELECT * FROM "SYS"."VIEW_COLUMNS"