H2 Database – Show


H2 Database – Show


”;


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

”;

Leave a Reply

Your email address will not be published. Required fields are marked *