Skip to Content
-1

How to get the count of Views in a HANA schema

May 08, 2017 at 10:15 AM

59

avatar image

Hello All,

I want to get the number/count of views present in the schema

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Florian Pfeffer
May 08, 2017 at 11:15 AM
1

You can use system view VIEWS for that.

For instance with following statement you get the number of views per schema in your system:

select schema_name, count(*) as no_of_views
from views
group by schema_name;
Share
10 |10000 characters needed characters left characters exceeded