- H2 Database Tutorial
- H2 Database - Home
- H2 Database - Introduction
- H2 Database - Installation
- H2 Database - Data Manipulation
- H2 Database - Select
- H2 Database - Insert
- H2 Database - Update
- H2 Database - Delete
- H2 Database - Backup
- H2 Database - Call
- H2 Database - Explain
- H2 Database - Merge
- H2 Database - Show
- H2 Database - Data Definition
- H2 Database - Create
- H2 Database - Alter
- H2 Database - Drop
- H2 Database - Truncate
- H2 Database - Commit
- H2 Database - Grant
- H2 Database - Savepoint
- H2 Database - Rollback
- H2 Database - JDBC Connection
- H2 Database Useful Resources
- H2 Database - Quick Guide
- H2 Database - Useful Resources
- H2 Database - Discussion
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