H2 Database - Show


Advertisements


SHOW is a command used to display the list of Schemas, Tables, or Columns of the table.

Syntax

Following is the generic syntax of the SHOW command.

SHOW { SCHEMAS | TABLES [ FROM schemaName ] | 
COLUMNS FROM tableName [ FROM schemaName ] } 

Example

The following command can be used to get the list of tables in the current database.

SHOW TABLES; 

The above command produces the following output.

TABLE_NAME TABLE_SCHEMA
CUSTOMER PUBLIC
EMP PUBLIC


Advertisements