8.6.78 getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) : Hitachi Advanced Database Application Development Guide

(1) Function

This method acquires information about tables.

The information about tables that can be acquired depends on the privileges of the HADB user who executes this method. For details about the privileges and the table 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.

To Page Top

(2) Format

public synchronized ResultSet getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) throws SQLException

To Page Top

(3) Arguments

String catalog

Specifies a catalog name. This argument is ignored, if specified.

String schemaPattern

Specifies a schema name pattern^#. This value is case sensitive.

String tableNamePattern

Specifies a table name pattern^#. This value is case sensitive.

String[] types

Specifies a list of table types. Specify table types returned by the getTableTypes method. This value is case sensitive.

If null is specified, the method assumes that the types of all tables were specified.

#

For details about the special characters that can be specified in each 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.

To Page Top

(4) Return value

The method returns a ResultSet object. The following table shows the format of the ResultSet object that is returned.

Table 8‒64: Format of the ResultSet object that is returned (getTables method)
Column No.	Type	Column name	Description
1	`String`	`TABLE_CAT`	The method always returns a null character string.
2	`String`	`TABLE_SCHEM`	Schema name
3	`String`	`TABLE_NAME`	Table name
4	`String`	`TABLE_TYPE`	Table type: `TABLE`: Base table `VIEW`: Viewed table `SYSTEM` `TABLE`: Dictionary table or system table
5	`String`	`REMARKS`	The method always returns a null character string.
6	`String`	`TYPE_CAT`	The method always returns a null character string..
7	`String`	`TYPE_SCHEM`	The method always returns a null character string..
8	`String`	`TYPE_NAME`	The method always returns a null character string..
9	`String`	`SELF_REFERENCING_COL_NAME`	The method always returns a null character string..
10	`String`	`REF_GENERATION`	The method always returns a null character string..

To Page Top

(5) Exceptions

The JDBC driver throws an SQLException in the following cases:

The Connection object is closed before this method is executed.
At least one element in the String[] types argument is null.
At least one element in the String[] types argument is not one of the following character strings:

"TABLE","VIEW", "SYSTEM TABLE"

To Page Top