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