8.6.75 getSuperTypes(String catalog, String schemaPattern, String typeNamePattern)
- Organization of this subsection
(1) Function
This method acquires information about the hierarchy of the user-defined types (UDTs) that are defined in a specific schema.
(2) Format
public synchronized ResultSet getSuperTypes(String catalog, String schemaPattern, String typeNamePattern) 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 typeNamePattern
-
Specifies a UDT (user-defined-type) 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 |
UDT's catalog name |
|
2 |
String |
TABLE_SCHEM |
UDT's schema name |
|
3 |
String |
TABLE_NAME |
UDT's type name |
|
4 |
String |
SUPERTYPE_CAT |
Catalog name of the direct super type |
|
5 |
String |
SUPERTYPE_SCHEM |
Schema name of the direct super type |
|
6 |
String |
SUPERTYPE_NAME |
Super type name of the direct super type |
(5) Exceptions
If this Connection object is closed before this method is executed, the JDBC driver throws an SQLException.