SAP HANA. SELECT all Attribute Views names from Schema [SQL script]

[Former Member]

Hi All,

I'd like to get all Attribute Views names from Schema.[pls see the screenshot].

I need the SQL script to get that Attribute views names.

Any suggestions?

Regards,

Arman.

[Former Member · Accepted solution]

Hi

Try the following

Select * from accessible_views where USER_NAME = <user>

It will display all available views. for that user.

The attribute views which are created comes under _SYS_BIC . You may try to filter

Select * from accessible_views where SCHEMA_NAME = '_SYS_BIC'

There is another view called VIEWS

Thanks and regards.

[Former Member · Accepted solution]

Hi Arun,

It worked.

Thank you very much!!

SELECT * FROM "SYS"."ACCESSIBLE_VIEWS" WHERE USER_NAME='SYSTEM'

AND SCHEMA_NAME = '_SYS_BIC'

AND VIEW_NAME LIKE 'ARM_TEST/%'

Regards,

Arman