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.

score 3 · Accepted Answer · answered Sep 27 '18 at 06:14

3

These are listed in the information_schema

So, you need to run:

select *
from information_schema.views;

answered Sep 27 '18 at 06:14

Thank you. For me it worked when I turned the tablename to uppercase. – Pierre-Henri Sudre Aug 04 '23 at 10:00

score 1 · Answer 2 · answered Sep 27 '18 at 06:16

1

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

answered Sep 27 '18 at 06:16

Eralper

score 1 · Answer 3 · answered Sep 27 '18 at 06:20

1

Try this one and it should work.

SELECT TABLE_NAME as [View Name]
FROM   INFORMATION_SCHEMA.VIEWS

answered Sep 27 '18 at 06:20

3 Answers3