getSuperTypes(String catalog, String schemaPattern, String typeNamePattern)

Syntax:

ResultSet getSuperTypes(String catalog,
                        String schemaPattern,
                        String typeNamePattern)
                        throws SQLException

Description:

Retrieves a description of the user-defined type (UDT) hierarchies defined in a particular schema in this database. Only the immediate super type/ sub type relationship is modeled.

Only supertype information for UDTs matching the catalog, schema, and type name is returned. The type name parameter may be a fully-qualified name. When the UDT name supplied is a fully-qualified name, the catalog and schemaPattern parameters are ignored.

If a UDT does not have a direct super type, it is not listed here. A row of the ResultSet object returned by this method describes the designated UDT and a direct supertype. A row has the following columns:

TYPE_CAT	String	the UDT's catalog (may be null)
TYPE_SCHEM	String	UDT's schema (may be null)
TYPE_NAME	String	type name of the UDT
SUPERTYPE_CAT	String	the direct super type's catalog (may be null)
SUPERTYPE_SCHEM	String	the direct super type's schema (may be null)
SUPERTYPE_NAME	String	the direct super type's name

Parameters:

catalog - a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria

schemaPattern - a schema name pattern; "" retrieves those without a schema

typeNamePattern - a UDT name pattern; may be a fully-qualified name

Returns:

a ResultSet object in which a row gives information about the designated UDT

Throws:

SQLException - if a database access error occurs