getSchemas(String catalog, String schemaPattern)

Syntax:

ResultSet getSchemas(String catalog,
                     String schemaPattern)
                     throws SQLException

Description:

Retrieves the schema names available in this database. The results are ordered by TABLE_CATALOG and TABLE_SCHEM.

The schema columns are:

TABLE_SCHEM	String	schema name
TABLE_CATALOG	String	catalog name (may be null)

Parameters:

catalog - a catalog name; must match the catalog name as it is stored in the database;"" retrieves those without a catalog; null means catalog name should not be used to narrow down the search.

schemaPattern - a schema name; must match the schema name as it is stored in the database; null means schema name should not be used to narrow down the search.

Returns:

a ResultSet object in which each row is a schema description

Throws:

SQLException - if a database access error occurs