Hitachi

Hitachi Advanced Database Application Development Guide


8.6.74 getSuperTables(String catalog, String schemaPattern, String tableNamePattern)

Organization of this subsection

(1) Function

This method acquires information about table hierarchies defined in a specific schema.

(2) Format

public synchronized ResultSet getSuperTables(String catalog, String schemaPattern, String tableNamePattern) throws SQLException

(3) Arguments

String catalog

Specifies a catalog name. This argument is ignored, if specified.

String schemaPattern

Specifies a schema name pattern. This argument is ignored, if specified.

String tableNamePattern

Specifies a table name pattern. This argument is ignored, if specified.

(4) Return value

This method always returns a ResultSet object that contains no retrieval result rows. The following table shows the format of the ResultSet object that is returned.

Table 8‒61: Format of the ResultSet object that is returned (getSuperTables method)

Column No.

Type

Column name

Description

1

String

TABLE_CAT

Catalog name

2

String

TABLE_SCHEM

Schema name

3

String

TABLE_NAME

Type name

4

String

SUPERTABLE_NAME

Super type name

(5) Exceptions

If this Connection object is closed before this method is executed, the JDBC driver throws an SQLException.