databaseh2database-view

H2 database: How to list all views?

What is a H2 command to list all views in the database?

I have expected that SHOW command would do the job but there is no option there to list views.

Solution

  • These are listed in the information_schema

    So, you need to run:

    select *
from information_schema.views;