如何查看HSQLDB数据库中的所有表？

SELECT * FROM INFORMATION_SCHEMA.SYSTEM_TABLES WHERE TABLE_TYPE='TABLE' AND TABLE_SCHEMA='PUBLIC';

SHOW TABLES;

Connection conn = DriverManager.getConnection("jdbc:hsqldb:file:mydb", "SA", "");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM INFORMATION_SCHEMA.SYSTEM_TABLES WHERE TABLE_TYPE='TABLE' AND TABLE_SCHEMA='PUBLIC'");
while (rs.next()) {
    String tableName = rs.getString("TABLE_NAME");
    System.out.println(tableName);
}