Database
Following examples show how to use H2 database SHOW statements.
Lists all table. For example:
CREATE TABLE TEST(ID INT PRIMARY KEY, NAME VARCHAR(255));
SHOW TABLES;
Lists all columns of a table. For example:
SHOW COLUMNS from TEST;
Lists all schemas:
SHOW SCHEMAS;