8.6.1 List of the methods in the DatabaseMetaData interface
- Organization of this subsection
(1) Main functions of the DatabaseMetaData Interface
The DatabaseMetaData interface provides the following main functions:
-
Return of various information about the connected database
-
Return of list information, such as lists of tables or columns (the information is stored in a ResultSet)
(2) Methods in the DatabaseMetaData interface that are supported by HADB
The following table lists and describes the methods in the DatabaseMetaData interface that are supported by HADB.
No. |
Method in the DatabaseMetaData interface |
Function |
---|---|---|
1 |
Acquires a value indicating whether all the procedures returned by the getProcedures method can be called by the current HADB user. |
|
2 |
Acquires a value indicating whether all the tables returned by the getTables method can be used by the current HADB user. |
|
3 |
Returns a value indicating whether all open ResultSet objects are to be closed if an SQLException occurs while the automatic commit mode is enabled. |
|
4 |
Acquires a value indicating whether a data definition statement in a transaction is to forcibly commit the transaction. |
|
5 |
Acquires a value indicating whether data definition statements are ignored in transactions. |
|
6 |
Acquires a value indicating whether deletions of visible rows can be detected by calling the rowDeleted method of the ResultSet class. |
|
7 |
Acquires a value indicating whether the getMaxRowSize method's return value contains the LONGVARCHAR or LONGVARBINARY SQL data type. |
|
8 |
Acquires a value indicating whether a generated key will always be returned if the column names or indexes specified for the auto-generated key columns are valid and the statement succeeds. |
|
9 |
Acquires information related to a specified attribute of a specified type for user-defined types (UDTs) that can be used in specified schemas and catalogs. |
|
10 |
getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable) |
Acquires information about the optimum column set for a table in which rows are identified uniquely. |
11 |
Acquires a catalog name. |
|
12 |
Acquires the separator between the catalog name and the table name. |
|
13 |
Acquires a word recommended for catalog. |
|
14 |
Returns a list of the client information properties supported by the driver. |
|
15 |
getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern) |
Acquires information about table column access permissions. |
16 |
getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) |
Acquires information about table columns. |
17 |
Acquires the Connection instance that created this DatabaseMetaData instance. |
|
18 |
Acquires cross-reference information between a specified referencing table and a specified referenced table. |
|
19 |
Acquires the major version of the database (HADB server). |
|
20 |
Acquires the minor version of the database (HADB server). |
|
21 |
Acquires the product name of the connected database (HADB server). |
|
22 |
Acquires the version of the connected database (HADB server). |
|
23 |
Acquires the default transaction isolation level for this database. |
|
24 |
Acquires the JDBC driver's major version. |
|
25 |
Acquires the JDBC driver's minor version. |
|
26 |
Acquires the JDBC driver's name. |
|
27 |
Acquires the JDBC driver's version. |
|
28 |
getExportedKeys(String catalog, String schema, String table) |
Acquires information about a referencing table's foreign keys. |
29 |
Acquires all the special characters that can be used in an ID name that is not enclosed in double quotation marks ("). |
|
30 |
Returns information about the function's parameters and the types that are returned. |
|
31 |
getFunctions(String catalog, String schemaPattern, String functionNamePattern) |
Returns information about the function. |
32 |
Acquires the character string used to enclose SQL identifiers. |
|
33 |
getImportedKeys(String catalog, String schema, String table) |
Acquires information about a referenced table's primary key. |
34 |
getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate) |
Acquires information about indexes. |
35 |
Acquires the driver's JDBC major version. |
|
36 |
Acquires the driver's JDBC minor version. |
|
37 |
Acquires the maximum number of hexadecimal characters that can be used in a binary literal. |
|
38 |
Acquires the maximum length of a catalog name (number of characters). |
|
39 |
Acquires the maximum length of an item of character string data (number of characters). |
|
40 |
Acquires the maximum length of a column name (number of characters). |
|
41 |
Acquires the maximum number of grouping columns that can be specified in the GROUP BY clause. |
|
42 |
Acquires the maximum number of columns that can comprise an index. |
|
43 |
Acquires the maximum number of columns that can be specified in an ORDER BY clause. |
|
44 |
Acquires the maximum number of selection expressions that can be specified in a selection list. |
|
45 |
Acquires the maximum number of columns that can be defined in a table. |
|
46 |
Acquires the maximum number of HADB clients that can connect concurrently to the HADB server. |
|
47 |
Acquires the maximum length of a cursor name (number of characters). |
|
48 |
Acquires the maximum length of an index key. |
|
49 |
Acquires the maximum number of bytes this database allows as the logical size for a LOB. |
|
50 |
Acquires the maximum length of a procedure name (number of characters). |
|
51 |
Acquires the maximum length of a row (in bytes). |
|
52 |
Acquires the maximum length of a schema name (number of characters). |
|
53 |
Acquires the maximum length of a character string that can be specified as an SQL statement. |
|
54 |
Acquires the maximum number of SQL statements that can be executed concurrently. |
|
55 |
Acquires the maximum length of a table name (number of characters). |
|
56 |
Acquires the maximum number of tables that can be specified in a SELECT statement. |
|
57 |
Acquires the maximum length of an authorization identifier (number of characters). |
|
58 |
Acquires a list of the available mathematical functions (delimited by the comma). |
|
59 |
Acquires information about a specified table's primary key columns. |
|
60 |
Acquires information about stored procedure parameters. |
|
61 |
getProcedures(String catalog, String schemaPattern, String procedureNamePattern) |
Acquires information about stored procedures. |
62 |
Acquires a word recommended for procedure. |
|
63 |
Acquires a description of the pseudo or hidden columns in a particular table within the specified catalog and schema. |
|
64 |
Acquires the holdability of the ResultSet object. |
|
65 |
Indicates whether the RowId type is supported. If the RowId type is supported, the method also indicates the period during which the RowId object is valid. |
|
66 |
Acquires schema names. |
|
67 |
Acquires schema names. |
|
68 |
Acquires a word recommended for schema. |
|
69 |
Acquires the character string used as the escape sequence for wildcard characters. |
|
70 |
Acquires a list (delimited by the comma) of all database-specific SQL keywords that are not SQL:2003 keywords. |
|
71 |
Acquires a value indicating whether SQLSTATE returned by the getSQLState method of the SQLException class is an X/Open (currently Open Group) SQL CLI or SQL:2003. |
|
72 |
Acquires a list of string functions (delimited by the comma). |
|
73 |
getSuperTables(String catalog, String schemaPattern, String tableNamePattern) |
Acquires information about table hierarchies defined in a specified schema. |
74 |
getSuperTypes(String catalog, String schemaPattern, String typeNamePattern) |
Acquires information about the hierarchy of the user-defined types (UDT) that are defined in a specific schema. |
75 |
Acquires the available system functions (delimited by the comma). |
|
76 |
getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern) |
Acquires information about access privileges for a table. |
77 |
getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) |
Acquires information about tables. |
78 |
Acquires the table types. |
|
79 |
Acquires a list of the available time and date functions (delimited by the comma). |
|
80 |
Acquires information about the default SQL types. |
|
81 |
getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types) |
Acquires information about the user-defined types (UDTs). |
82 |
Acquires the URL that specifies information about the HADB server at the connection destination. |
|
83 |
Acquires the authorization identifier used to connect to the HADB server. |
|
84 |
getVersionColumns(String catalog, String schema, String table) |
Acquires information about the table columns that are updated automatically when rows in the table are modified. |
85 |
Acquires a value indicating whether insertion of a visible row can be detected by calling the rowInserted method of the ResultSet class. |
|
86 |
Acquires a value indicating whether a catalog appears as the leading (or trailing) part of a fully qualified table name. |
|
87 |
Acquires a value indicating whether the database is in the read-only mode. |
|
88 |
Acquires a value indicating whether a change was made to a copy of a LOB or directly to the LOB. |
|
89 |
Acquires a value indicating whether a join of a null value and a non-null value is treated as being a null value. |
|
90 |
Acquires a value indicating whether null values are sorted at the end regardless of the sort order. |
|
91 |
Acquires a value indicating whether null values are sorted at the start regardless of the sort order. |
|
92 |
Acquires a value indicating whether null values are sorted in ascending order. |
|
93 |
Acquires a value indicating whether null values are sorted low. |
|
94 |
Acquires a value indicating whether a deletion performed externally is visible. |
|
95 |
Acquires a value indicating whether an insertion performed externally is visible. |
|
96 |
Acquires a value indicating whether an updating performed externally is visible. |
|
97 |
Acquires a value indicating whether a deletion of a result set itself is visible. |
|
98 |
Acquires a value indicating whether an insertion of a result set itself is visible. |
|
99 |
Acquires a value indicating whether an updating of a result set itself is visible. |
|
100 |
Acquires a value indicating whether an SQL identifier containing uppercase and lowercase letters that is not enclosed in double quotation marks is processed as being not case sensitive, and then the results are stored in all lowercase letters. |
|
101 |
Acquires a value indicating whether an SQL identifier containing uppercase and lowercase letters that is enclosed in double quotation marks is processed as being not case sensitive, and then the results are stored in all lowercase letters. |
|
102 |
Acquires a value indicating whether an SQL identifier containing uppercase and lowercase letters that is not enclosed in double quotation marks is processed as being not case sensitive, and then the results are stored in uppercase and lowercase letters. |
|
103 |
Acquires a value indicating whether an SQL identifier containing uppercase and lowercase letters that is enclosed in double quotation marks is processed as being not case sensitive, and then the results are stored in uppercase and lowercase letters. |
|
104 |
Acquires a value indicating whether an SQL identifier containing uppercase and lowercase letters that is not enclosed in double quotation marks is processed as being not case sensitive, and then the results are stored in all uppercase letters. |
|
105 |
Acquires a value indicating whether an SQL identifier containing uppercase and lowercase letters that is enclosed in double quotation marks is processed as being not case sensitive, and then the results are stored in all uppercase letters. |
|
106 |
Acquires a value indicating whether ALTER TABLE with added columns is supported. |
|
107 |
Acquires a value indicating whether ALTER TABLE with dropped columns is supported. |
|
108 |
Acquires a value indicating whether the ANSI92 entry-level SQL grammar is supported. |
|
109 |
Acquires a value indicating whether the ANSI92 full-level SQL grammar is supported. |
|
110 |
Acquires a value indicating whether the ANSI92 intermediate-level SQL grammar is supported. |
|
111 |
Acquires a value indicating whether batch updating is supported. |
|
112 |
Acquires a value indicating whether catalog names can be used in data manipulation statements. |
|
113 |
Acquires a value indicating whether catalog names can be used in index definition statements. |
|
114 |
Acquires a value indicating whether catalog names can be used in definition statements for granting privileges (GRANT statement) or revoking privileges (REVOKE statement). |
|
115 |
Acquires a value indicating whether catalog names can be used in procedure call statements. |
|
116 |
Acquires a value indicating whether catalog names can be used in table definition statements. |
|
117 |
Acquires a value indicating whether aliases are supported for columns. |
|
118 |
Acquires a value indicating whether the CONVERT function is supported for SQL types. |
|
119 |
Acquires a value indicating whether the CONVERT function is supported for specified SQL types. |
|
120 |
Acquires a value indicating whether the ODBC Core SQL grammar is supported. |
|
121 |
Acquires a value indicating whether subqueries that contain external reference columns are supported. |
|
122 |
Acquires a value indicating whether data definition statements and data manipulation statements are both supported in transactions. |
|
123 |
Acquires a value indicating whether only data manipulation statements are supported in transactions. |
|
124 |
Acquires a value indicating whether the table names must be different from the correlation names when table correlation names are supported. |
|
125 |
Acquires a value indicating whether value expressions are supported in an ORDER BY list. |
|
126 |
Acquires a value indicating whether the ODBC Extended SQL grammar is supported. |
|
127 |
Acquires a value indicating whether nested full outer joins are supported. |
|
128 |
Acquires a value indicating whether automatic generation keys can be acquired after statements have executed. |
|
129 |
Acquires a value indicating whether the GROUP BY clause form is supported. |
|
130 |
Acquires a value indicating whether a column that is not in the SELECT statement can be used in the GROUP BY clause, provided that all columns in the SELECT statement are included in the GROUP BY clause. |
|
131 |
Acquires a value indicating whether a column that is not in the SELECT statement can be used in the GROUP BY clause. |
|
132 |
Acquires a value indicating whether the SQL Integrity Enhancement Facility is supported. |
|
133 |
Acquires a value indicating whether the escape clause is supported in the LIKE clause. |
|
134 |
Acquires a value indicating whether limited support is provided for outer joins. |
|
135 |
Acquires a value indicating whether the ODBC Minimum SQL grammar is supported. |
|
136 |
Acquires a value indicating whether an SQL identifier containing uppercase and lowercase letters that is not enclosed in double quotation marks is processed as being case sensitive, and then the results are stored in uppercase and lowercase letters. |
|
137 |
Acquires a value indicating whether an SQL identifier containing uppercase and lowercase letters that is enclosed in double quotation marks is processed as being case sensitive, and then the results are stored in uppercase and lowercase letters. |
|
138 |
Acquires a value indicating whether it is possible to have multiple ResultSet objects that have been returned by a CallableStatement object. |
|
139 |
Acquires a value indicating whether multiple ResultSet objects can be acquired from a single call of the execute method. |
|
140 |
Acquires a value indicating whether multiple transactions can be open at the same time (for different connections). |
|
141 |
Acquires a value indicating whether named parameters are supported for the CALL statement. |
|
142 |
Acquires a value indicating whether columns can be defined as non-null columns. |
|
143 |
Acquires a value indicating whether the cursor can remain open between commit operations. |
|
144 |
Acquires a value indicating whether the cursor can remain open between rollback operations. |
|
145 |
Acquires a value indicating whether the statement handle can remain open between commit operations. |
|
146 |
Acquires a value indicating whether the statement handle can remain open between rollback operations. |
|
147 |
Acquires a value indicating whether a column that is not in the SELECT statement can be used in the ORDER BY clause. |
|
148 |
Acquires a value indicating whether some form of outer join is supported. |
|
149 |
Acquires a value indicating whether positioned DELETE statements are supported. |
|
150 |
Acquires a value indicating whether positioned UPDATE statements are supported. |
|
151 |
Acquires a value indicating whether the database supports REF CURSOR. |
|
152 |
Acquires a value indicating whether the combination of a specified result set type and a specified concurrent processing type is supported. |
|
153 |
Acquires a value indicating whether holdability is supported for the specified ResultSet object. |
|
154 |
Acquires a value indicating whether a specified result set type is supported. |
|
155 |
Acquires a value indicating whether save points are supported. |
|
156 |
Acquires a value indicating whether schema names can be used in data manipulation statements. |
|
157 |
Acquires a value indicating whether schema names can be used in index definition statements. |
|
158 |
Acquires a value indicating whether schema names can be used in definition statements for granting privileges (GRANT statement) or revoking privileges (REVOKE statement). |
|
159 |
Acquires a value indicating whether schema names can be used in procedure call statements. |
|
160 |
Acquires a value indicating whether schema names can be used in table definition statements. |
|
161 |
Acquires a value indicating whether SELECT FOR UPDATE statements are supported. |
|
162 |
Acquires a value indicating whether pooling of statement handles is supported. |
|
163 |
Acquires a value indicating whether user-defined functions or vendor functions that use a stored procedure escape syntax are supported. |
|
164 |
Acquires a value indicating whether stored procedure calls that use a stored procedure escape syntax are supported. |
|
165 |
Acquires a value indicating whether subqueries are supported in comparison predicates. |
|
166 |
Acquires a value indicating whether subqueries are supported in EXISTS predicates. |
|
167 |
Acquires a value indicating whether subqueries are supported in IN predicates. |
|
168 |
Acquires a value indicating whether subqueries are supported in quantified predicates. |
|
169 |
Acquires a value indicating whether subqueries are supported in quantified predicates. |
|
170 |
Returns a value indicating whether a specified transaction isolation level is supported. |
|
171 |
Acquires a value indicating whether transactions are supported. |
|
172 |
Acquires a value indicating whether SQL UNION is supported. |
|
173 |
Acquires a value indicating whether SQL UNION ALL is supported. |
|
174 |
Acquires a value indicating whether updating performed on visible rows can be detected by calling the rowUpdated method of the ResultSet class. |
|
175 |
Acquires a value indicating whether a file is to be used for each table. |
|
176 |
Acquires a value indicating whether tables are to be stored in local files. |
- Important
-
HADB does not support methods that are not listed in this table. If an unsupported method is executed, an SQLException might be thrown.
(3) Required package name and class name
The package and class names required in order to use the DatabaseMetaData interface are as follows:
-
Package name: com.hitachi.hadb.jdbc
-
Class name: AdbDatabaseMetaData
(4) Special characters that can be specified in pattern character strings
Some methods in the DatabaseMetaData class use a String pattern character string as an argument. The following table shows the special characters that can be specified in such a pattern character string.
Special character that can be specified |
Description |
---|---|
_ (underscore) |
Any single character |
% |
A character string of any length, including no characters. |
\ |
An escape character. Special characters that immediately follow the escape character in a pattern character string are treated as normal characters. The character \ is represented by the Shift-JIS code 0x5c (0x5c00 in UTF-16LE). In UTF-8, specify the character that appears as a backslash \. |