Skip to Content
avatar image
-1
Former Member

How to get the count of Views in a HANA schema

Hello All,

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    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