H2 Database - Show
Donald Green
0
23
SHOW is a command used to display a list of schemas, tables, or table columns.
Syntax
Following is the general syntax of the SHOW command.
SHOW { SCHEMAS | TABLES [ FROM schemaName ] | COLUMNS FROM tableName [ FROM schemaName ] }
example
The following command can be used to get a list of tables in the current database.
SHOW TABLES ;
The above command produces the following output.
