H2 database SHOW statements

Database 

Following examples show how to use H2 database SHOW statements.

SHOW TABLES

Lists all table. For example:

CREATE TABLE TEST(ID INT PRIMARY KEY, NAME VARCHAR(255));

SHOW TABLES;

SHOW COLUMNS

Lists all columns of a table. For example:

CREATE TABLE TEST(ID INT PRIMARY KEY, NAME VARCHAR(255));

SHOW COLUMNS from TEST;

SHOW SCHEMAS

Lists all schemas:

SHOW SCHEMAS;