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

(1) Function

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

To Page Top

(2) Format

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

To Page Top

(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.

To Page Top

(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

To Page Top

(5) Exceptions

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

To Page Top