8.6.68 getSchemas(String catalog, String schemaPattern)
- Organization of this subsection
(1) Function
This method acquires schema names.
The information about schemas that can be acquired depends on the privileges of the HADB user who executes this method. For details about the privileges and the schema information that can be acquired, see the topic Scope of information in dictionary tables and system tables that can be referenced by HADB users in the HADB Setup and Operation Guide.
(2) Format
public synchronized ResultSet getSchemas(String catalog, String schemaPattern) 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 case sensitive.
For details about the special characters that can be specified in the pattern, see (4) Special characters that can be specified in pattern character strings in 8.6.1 List of the methods in the DatabaseMetaData interface.
(4) Return value
This method returns a ResultSet object.
The following table shows the format of the ResultSet object that is returned.
|
Column No. |
Type |
Column name |
Description |
|---|---|---|---|
|
1 |
String |
TABLE_SCHEM |
Schema name |
|
2 |
String |
TABLE_CATALOG |
The method always returns a null character string. |