CODEWITHSUNDEEP
databaseh2database-view
tomto
tomto

Reputation: 33

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.

Upvotes: 3

Views: 3334

Answers (3)

Narayan Yerrabachu
Narayan Yerrabachu

Reputation: 1823

Try this one and it should work.

SELECT TABLE_NAME as [View Name]
FROM   INFORMATION_SCHEMA.VIEWS

H2 Database

Upvotes: 1

Eralper
Eralper

Reputation: 6622

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

Upvotes: 1

user330315
user330315

Reputation:

These are listed in the information_schema

So, you need to run:

select *
from information_schema.views;

Upvotes: 3

Related Questions