H2 database: How to list all views?

Question

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.

Answer 1

These are listed in the information_schema

So, you need to run:

select *
from information_schema.views;

Answer 2

please check System Tables provided for H2 database engine under INFORMATION_SCHEMA schema

You can display all views by querying INFORMATION_SCHEMA.VIEWS system table

Answer 3

Try this one and it should work.

SELECT TABLE_NAME as [View Name]
FROM   INFORMATION_SCHEMA.VIEWS 

H2 Database