Question Re: SAP HANA. SELECT all Attribute Views names from Schema [SQL script] in Technology Q&A

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

Former Member — Mon, 04 Jul 2016 02:36:25 GMT

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 — Mon, 04 Jul 2016 05:06:33 GMT

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 — Mon, 04 Jul 2016 05:15:36 GMT

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