H2 Database 简明教程 H2 Database - Show H2 Database 简明教程 H2 Database - Show SHOW 是用于显示架构、表或表列的命令。 SHOW is a command used to display the list of Schemas, Tables, or Columns of the table. Syntax 以下是 SHOW 命令的通用语法。 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