Skip to Content
avatar image
-1
Former Member

How to get the count of Views in a HANA schema

May 08, 2017 at 10:15 AM | 72 Views

Hello All,

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

SAP HANA
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Florian Pfeffer
    May 08, 2017 at 11:15 AM

    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;
    Add comment
    10|10000 characters needed characters exceeded