DatabaseMetaData

States that it may not be permitted to store NULL values.

States that NULL values are definitely permitted.

States that whether NULL values are permitted is unknown.

States the best row identifier is NOT a pseudo column.

States that the best row identifier is a pseudo column.

States that the remainder of the current session is used as the scope for the best row identifier.

States that best row identifier scope lasts only while the row is being used.

States that the remainder of the current transaction is used as the scope for the best row identifier.

States that the best row identifier may or may not be a pseudo column.

States that the column might not allow NULL values.

States that the column definitely allows NULL values.

States that it is unknown whether the columns may be nulled.

For the column UPDATE_RULE, States that when the primary key is updated, the foreign key (imported key) is changed to agree with it.

States deferrability.

States defer-ability.

For the columns UPDATE_RULE and DELETE_RULE, States that if the primary key has been imported, it cannot be updated or deleted.

States defer-ability.

States that a primary key must not be updated when imported as a foreign key by some other table. Used for the column UPDATE_RULE.

States that when the primary key is modified (updated or deleted) the foreign (imported) key is changed to its default value. Applies to the UPDATE_RULE and DELETE_RULE columns.

States that when the primary key is modified (updated or deleted) the foreign (imported) key is changed to NULL. Applies to the UPDATE_RULE and DELETE_RULE columns.

States that this column stores IN type parameters.

States that this column stores INOUT type parameters.

States that this column stores OUT type parameters.

States that the column stores results

States that the column stores return values.

States that type of the column is unknown.

States that NULL values are not permitted.

States that the procedure does not return a result.

States that NULL values are permitted.

States that whether NULL values are permitted is unknown.

States that it is unknown whether or not the procedure returns a result.

States that the procedure returns a result.

States that the value is an SQL99 SQLSTATE value.

States that the value is an SQL CLI SQLSTATE value as defined by X/Open (who are now know as Open Group) .

States that this table index is a clustered index.

States that this table index is a hashed index.

States this table's index is neither a clustered index, not a hashed index, and not a table statistics index; i.e. it is something else.

States this column has the table's statistics, and that it is returned in conjunction with the table's index description.

States that a NULL value is NOT permitted for this data type.

States that a NULL value is permitted for this data type.

States that it is unknown if a NULL value is permitted for this data type.

States that one can base all WHERE search clauses except WHERE .

States that WHERE is the only WHERE search clause that may be based on this type.

States that this type does not support WHERE search clauses.

States that all WHERE search clauses may be based on this type.

States that the version column is known to be not a pseudo column.

States that this version column is known to be a pseudo column.

States that the version column may be a pseudo column or not.

Returns whether all procedures returned by getProcedures can be called by the current user.

Returns whether all the tables returned by getTables can be used by the current user in a SELECT statement.

Returns if a data definition statement in a transaction forces a commit of the transaction.

Returns whether the database ignores data definition statements within a transaction.

Returns whether a visible row delete can be detected by calling ResultSet.rowDeleted.

Returns whether the return value of getMaxRowSize includes the SQL data types LONGVARCHAR and LONGVARBINARY.

Returns a description of the specified attribute of the specified type for an SQL User Defined Type (UDT) for a specified schema and catalog. The descriptions returned are ordered by TYPE_SCHEM, TYPE_NAME and ORDINAL_POSITION. The descriptions do not contain inherited attributes.

The returned ResultSet object has rows with the following column names and meanings:

1. TYPE_CAT - String - the Type Catalog name (possibly null)
2. TYPE_SCHEM - String - the Type Schema name (possibly null)
3. TYPE_NAME - String - the Type name
4. ATTR_NAME - String - the Attribute name
5. DATA_TYPE - int - the Attribute type as defined in java.sql.Types
6. ATTR_TYPE_NAME - String - the Attribute type name. This depends on the data source. For a UDT the name is fully qualified. For a REF it is both fully qualified and represents the target type of the reference.
7. ATTR_SIZE - int - the Column size. When referring to char and date types this value is the maximum number of characters. When referring to numeric types is is the precision.
8. DECIMAL_DIGITS - int - how many fractional digits are supported
9. NUM_PREC_RADIX - int - numeric values radix
10. NULLABLE - int - whether NULL is permitted:
    • DatabaseMetaData.attributeNoNulls - might not allow NULLs
    • DatabaseMetaData.attributeNullable - NULLs definitely permitted
    • DatabaseMetaData.attributeNullableUnknown - unknown
11. REMARKS - String - A comment describing the attribute (possibly null)
12. ATTR_DEF - String - Default value for the attribute (possibly null)
13. SQL_DATA_TYPE - int - not used
14. SQL_DATETIME_SUB - int - not used
15. CHAR_OCTET_LENGTH - int - For CHAR types, the max number of bytes in the column
16. ORDINAL_POSITION - int - The Index of the column in the Table (based on 1)
17. IS_NULLABLE - String - "NO" = column does not allow NULLs, "YES" = column allows NULLs "" = NULL status unknown
18. SCOPE_CATALOG - String - Catalog for table, SCOPE of Reference attribute. NULL if DATA_TYPE is not REF.
19. SCOPE_SCHEMA - String - Schema for table, SCOPE of Reference attribute. NULL if DATA_TYPE is not REF.
20. SCOPE_TABLE - String - Table name for SCOPE of Reference attribute. NULL if DATA_TYPE is not REF.
21. SOURCE_DATA_TYPE - String - The source type for user generated REF type or for a Distinct type. (NULL if DATA_TYPE is not DISTINCT or user generated REF)

Returns a list of a table's optimal set of columns that uniquely identifies a row. The results are ordered by SCOPE (see below).

The results are returned as a table, with one entry for each column, as follows:

1. SCOPE - short - the SCOPE of the result, as follows:
   • DatabaseMetaData.bestRowTemporary - very temporary, while using row
   • DatabaseMetaData.bestRowTransaction - good for remainder of current transaction
   • DatabaseMetaData.bestRowSession - good for remainder of database session
2. COLUMN_NAME - String - the column name
3. DATA_TYPE - int - the Type of the data, as defined in java.sql.Types
4. TYPE_NAME - String - Name of the type - database dependent. For UDT types the name is fully qualified
5. COLUMN_SIZE - int - The precision of the data in the column
6. BUFFER_LENGTH - int - not used
7. DECIMAL_DIGITS - short - number of fractional digits
8. PSEUDO_COLUMN - short - whether this is a pseudo column eg. and Oracle ROWID:
   • DatabaseMetaData.bestRowUnknown - don't know whether this is a pseudo column
   • DatabaseMetaData.bestRowNotPseudo - column is not pseudo
   • DatabaseMetaData.bestRowPseudo - column is a pseudo column

Returns the separator that this database uses between a catalog name and table name.

Returns the term that the database vendor prefers term for "catalog".

Returns the set of catalog names available in this database. The set is returned ordered by catalog name.

Returns a description of access rights for a table's columns. Only access rights matching the criteria for the column name are returned.

The description is returned as a ResultSet with rows of data for each access right, with columns as follows:

1. TABLE_CAT - String - Catalog name (possibly null)
2. TABLE_SCHEM - String - Schema name (possibly null)
3. TABLE_NAME - String - The Table name
4. COLUMN_NAME - String - The Column name
5. GRANTOR - String - The grantor of access (possibly null)
6. PRIVILEGE - String - Access right - one of SELECT, INSERT, UPDATE, REFERENCES,...
7. IS_GRANTABLE - String - "YES" implies that the receiver can grant access to others, "NO" if the receiver cannot grant access to others, null if unknown.

Returns a description of table columns available in a specified catalog. Only descriptions meeting the specified Catalog, Schema, Table and Column names are returned.

The descriptions are returned as a ResultSet conforming to the following data layout, with one row per table column:

1. TABLE_CAT - String - Catalog name (possibly null)
2. TABLE_SCHEM - String - Schema name (possibly null)
3. TABLE_NAME - String - The Table name
4. COLUMN_NAME - String - The Column name
5. DATA_TYPE - int - The SQL type as specified in java.sql.Types
6. TYPE_NAME - String - Name for the data type, depends on database, UDT names are fully qualified
7. COLUMN_SIZE - int - Column size - the precision for numeric types, max characters for char and date types
8. BUFFER_LENGTH - int - Not used
9. DECIMAL_DIGITS - int - maximum number of fractional digits
10. NUM_PREC_RADIX - int - the Radix
11. NULLABLE - int - does the column allow nulls:
    • DatabaseMetaData.columnNoNulls = may not allow NULLs
    • DatabaseMetaData.columnNullable = does allow NULLs
    • DatabaseMetaData.columnNullableUnknown = unknown NULL status
12. REMARKS - String - A description of the column (possibly null)
13. COLUMN_DEF - String - Default value for the column (possibly null)
14. SQL_DATA_TYPE - int - not used
15. SQL_DATETIME_SUB - int - not used
16. CHAR_OCTET_LENGTH - int - maximum number of bytes in the char type columns
17. ORDINAL_POSITION - int - Column index in the table (1 based)
18. IS_NULLABLE - String - "NO" = column does not allow NULLs, "YES" = column allows NULLs "" = NULL status unknown
19. SCOPE_CATALOG - String - Catalog for table, SCOPE of Reference attribute. NULL if DATA_TYPE is not REF.
20. SCOPE_SCHEMA - String - Schema for table, scope of Reference attribute. NULL if DATA_TYPE is not REF.
21. SCOPE_TABLE - String - Table name for scope of Reference attribute. NULL if DATA_TYPE is not REF.
22. SOURCE_DATA_TYPE - String - The source type for user generated REF type or for a Distinct type. (NULL if DATA_TYPE is not DISTINCT or user generated REF)

Returns the database connection that created this metadata.

Returns a list of foreign key columns in a given foreign key table that reference the primary key columns of a supplied primary key table. This describes how one table imports the key of another table. It would be expected to return a single foreign key - primary key pair in most cases.

The descriptions are returned as a ResultSet with one row for each Foreign key, with the following layout:

1. PKTABLE_CAT - String - from the primary key table : Catalog (possibly null)
2. PKTABLE_SCHEM - String - from the primary key table : Schema (possibly null)
3. PKTABLE_NAME - String - primary key table : name
4. PKCOLUMN_NAME - String - primary key column : name
5. FKTABLE_CAT - String - from the foreign key table : the catalog name being exported (possibly null)
6. FKTABLE_SCHEM - String - foreign key table : Schema name being exported (possibly null)
7. FKTABLE_NAME - String - foreign key table : the name being exported
8. FKCOLUMN_NAME - String - foreign key column : the name being exported
9. KEY_SEQ - short - sequence number (in the foreign key)
10. UPDATE_RULE - short - how to treat foreign key when primary key is updated:
    • DatabaseMetaData.importedKeyNoAction - don't allow update of primary key if imported
    • DatabaseMetaData.importedKeyCascade - change imported key to match the primary key update
    • DatabaseMetaData.importedKeySetNull - set the imported key to null
    • DatabaseMetaData.importedKeySetDefault - set the imported key to default values
    • DatabaseMetaData.importedKeyRestrict - same as importedKeyNoAction
11. DELETE_RULE - short - how to treat foreign key when primary key is deleted:
    • DatabaseMetaData.importedKeyNoAction - don't allow delete of primary key if imported
    • DatabaseMetaData.importedKeyCascade - delete those rows that import a deleted key
    • DatabaseMetaData.importedKeySetNull - set the imported key to null
    • DatabaseMetaData.importedKeySetDefault - set the imported key to default values
    • DatabaseMetaData.importedKeyRestrict - same as importedKeyNoAction
12. FK_NAME - String - foreign key name (possibly null)
13. PK_NAME - String - primary key name (possibly null)
14. DEFERRABILITY - short - can foreign key constraints be deferred until commit (see SQL92 specification for definitions)?:
    • DatabaseMetaData.importedKeyInitiallyDeferred
    • DatabaseMetaData.importedKeyInitiallyImmediate
    • DatabaseMetaData.importedKeyNotDeferrable

Returns the major version number of the database software.

Returns the minor version number of the database software.

Returns the name of the database software.

Returns the version number of this database software.

Returns the default transaction isolation level for this database.

Returns the JDBC driver's major version number.

Returns the JDBC driver's minor version number.

Returns the name of this JDBC driver.

Returns the version number of this JDBC driver.

Returns a list of the foreign key columns that reference the primary key columns of a specified table (the foreign keys exported by a table).

The list is returned as a ResultSet with a row for each of the foreign key columns, ordered by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, and KEY_SEQ, with the format for each row being:

1. PKTABLE_CAT - String - primary key table : Catalog (possibly null)
2. PKTABLE_SCHEM - String - primary key table : Schema (possibly null)
3. PKTABLE_NAME - String - primary key table : name
4. PKCOLUMN_NAME - String - primary key column : name
5. FKTABLE_CAT - String - foreign key table : Catalog name being exported (possibly null)
6. FKTABLE_SCHEM - String - foreign key table : Schema name being exported (possibly null)
7. FKTABLE_NAME - String - foreign key table : name being exported
8. FKCOLUMN_NAME - String - foreign key column : name being exported
9. KEY_SEQ - short - sequence number in the foreign key
10. UPDATE_RULE - short - how to treat foreign key when primary key is updated:
    • DatabaseMetaData.importedKeyNoAction - don't allow update of primary key if imported
    • DatabaseMetaData.importedKeyCascade - change imported key to match the primary key update
    • DatabaseMetaData.importedKeySetNull - set the imported key to null
    • DatabaseMetaData.importedKeySetDefault - set the imported key to default values
    • DatabaseMetaData.importedKeyRestrict - same as importedKeyNoAction
11. DELETE_RULE - short - how to treat foreign key when primary key is deleted:
    • DatabaseMetaData.importedKeyNoAction - don't allow delete of primary key if imported
    • DatabaseMetaData.importedKeyCascade - the deletion should also delete rows that import a deleted key
    • DatabaseMetaData.importedKeySetNull - it should set the imported key to null
    • DatabaseMetaData.importedKeySetDefault - deletion sets the imported key to default values
    • DatabaseMetaData.importedKeyRestrict - same as importedKeyNoAction
12. FK_NAME - String - foreign key name (possibly null)
13. PK_NAME - String - primary key name (possibly null)
14. DEFERRABILITY - short - defines whether foreign key constraints can be deferred until commit (see SQL92 specification for definitions):
    • DatabaseMetaData.importedKeyInitiallyDeferred
    • DatabaseMetaData.importedKeyInitiallyImmediate
    • DatabaseMetaData.importedKeyNotDeferrable

Returns a string of characters that may be used in unquoted identifier names. The characters a-z, A-Z, 0-9 and _ are always permitted.

Returns the string used to quote SQL identifiers. Returns " " (space) if identifier quoting not supported.

Returns a list columns in a table that are both primary keys and referenced by the table's foreign key columns (that is, the primary keys imported by a table).

The list returned is a ResultSet with a row entry for each primary key column, ordered by PKTABLE_CAT, PKTABLE_SCHEM, PKTABLE_NAME, and KEY_SEQ, with the following format:

1. PKTABLE_CAT - String - primary key Catalog name being imported (possibly null)
2. PKTABLE_SCHEM - String - primary key Schema name being imported (possibly null)
3. PKTABLE_NAME - String - primary key Table name being imported
4. PKCOLUMN_NAME - String - primary key column name being imported
5. FKTABLE_CAT - String - foreign key table catalog name (possibly null)
6. FKTABLE_SCHEM - String - foreign key table Schema name (possibly null)
7. FKTABLE_NAME - String - foreign key table name
8. FKCOLUMN_NAME - String - foreign key column name
9. KEY_SEQ - short - sequence number in the foreign key
10. UPDATE_RULE - short - how to treat foreign key when primary key is updated:
    • DatabaseMetaData.importedKeyNoAction - don't allow update of primary key if imported
    • DatabaseMetaData.importedKeyCascade - change imported key to match the primary key update
    • DatabaseMetaData.importedKeySetNull - set the imported key to null
    • DatabaseMetaData.importedKeySetDefault - set the imported key to default values
    • DatabaseMetaData.importedKeyRestrict - same as importedKeyNoAction
11. DELETE_RULE - short - how to treat foreign key when primary key is deleted:
    • DatabaseMetaData.importedKeyNoAction - don't allow delete of primary key if imported
    • DatabaseMetaData.importedKeyCascade - delete those rows that import a deleted key
    • DatabaseMetaData.importedKeySetNull - set the imported key to null
    • DatabaseMetaData.importedKeySetDefault - set the imported key to default values
    • DatabaseMetaData.importedKeyRestrict - same as importedKeyNoAction
12. FK_NAME - String - foreign key name (possibly null)
13. PK_NAME - String - primary key name (possibly null)
14. DEFERRABILITY - short - defines whether foreign key constraints can be deferred until commit (see SQL92 specification for definitions):
    • DatabaseMetaData.importedKeyInitiallyDeferred
    • DatabaseMetaData.importedKeyInitiallyImmediate
    • DatabaseMetaData.importedKeyNotDeferrable

Returns a list of indices and statistics for a specified table.

The list is returned as a ResultSet, with one row for each index or statistic. The list is ordered by NON_UNIQUE, TYPE, INDEX_NAME, and ORDINAL_POSITION. Each row has the following format:

1. TABLE_CAT - String - table catalog name (possibly null)
2. TABLE_SCHEM - String - Table Schema name (possibly null)
3. TABLE_NAME - String - The Table name
4. NON_UNIQUE - boolean - true when index values can be non-unique. Must be false when TYPE is tableIndexStatistic
5. INDEX_QUALIFIER - String : index catalog name. null when TYPE is 'tableIndexStatistic'
6. INDEX_NAME - String : index name. null when TYPE is 'tableIndexStatistic'
7. TYPE - short - the index type. One of:
   • DatabaseMetaData.tableIndexStatistic - table statistics returned with Index descriptions
   • DatabaseMetaData.tableIndexClustered - a clustered Index
   • DatabaseMetaData.tableIndexHashed - a hashed Index
   • DatabaseMetaData.tableIndexOther - other style of Index
8. ORDINAL_POSITION - short - column sequence within Index. 0 when TYPE is tableIndexStatistic
9. COLUMN_NAME - String - the column name. null when TYPE is tableIndexStatistic
10. ASC_OR_DESC - String - column sort sequence. null if sequencing not supported or TYPE is tableIndexStatistic; otherwise "A" means sort ascending and "D" means sort descending.
11. CARDINALITY - int - Number of unique values in the Index. If TYPE is tableIndexStatistic, this is number of rows in the table.
12. PAGES - int - Number of pages for current Index. If TYPE is tableIndexStatistic, this is number of pages used for the table.
13. FILTER_CONDITION - String - Filter condition. (possibly null)

Returns this driver's major JDBC version number.

Returns the minor JDBC version number for this driver.

Get the maximum number of hex characters in an in-line binary literal for this database.

Returns the maximum size of a Catalog name in this database.

Returns the maximum size for a character literal in this database.

Returns the maximum size for a Column name for this database.

Get the maximum number of columns in a GROUP BY clause for this database.

Returns the maximum number of columns in an Index for this database.

Returns the maximum number of columns in an ORDER BY clause for this database.

Returns the maximum number of columns in a SELECT list for this database.

Returns the maximum number of columns in a table for this database.

Returns the database's maximum number of concurrent connections.

Returns the maximum length of a cursor name for this database.

Returns the maximum length in bytes for an Index for this database. This covers all the parts of a composite index.

Returns the maximum number of characters for a procedure name in this database.

Returns the maximum number of bytes within a single row for this database.

Returns the maximum number of characters in a schema name for this database.

Returns the maximum number of characters in an SQL statement for this database.

Get the maximum number of simultaneously open active statements for this database.

Returns the maximum size for a table name in the database.

Returns the maximum number of tables permitted in a SELECT statement for the database.

Returns the maximum number of characters in a user name for the database.

Returns a list of the math functions available with this database. These are used in the JDBC function escape clause and are the Open Group CLI math function names.

Returns a list of the primary key columns of a specified table.

The list is returned as a ResultSet with one row for each primary key column, ordered by COLUMN_NAME, with each row having the structure as follows:

1. TABLE_CAT - String - table catalog name (possibly null)
2. TABLE_SCHEM - String - Table Schema name (possibly null)
3. TABLE_NAME - String - The Table name
4. COLUMN_NAME - String - The Column name
5. KEY_SEQ - short - the sequence number for this column in the primary key
6. PK_NAME - String - the primary key name (possibly null)

Returns a list of parameter and result columns for the stored procedures belonging to a specified Catalog.

The list is returned as a ResultSet with one row for each parameter or result column. The data is ordered by PROCEDURE_SCHEM and PROCEDURE_NAME, while for each procedure, the return value (if any) is first, followed by the parameters in the order they appear in the stored procedure call, followed by ResultSet columns in column number order. Each row has the following structure:

1. PROCEDURE_CAT - String - the procedure catalog name
2. PROCEDURE_SCHEM - String - the procedure schema name (possibly null)
3. PROCEDURE_NAME - String - the procedure name
4. COLUMN_NAME - String - the name of the column
5. COLUMN_TYPE - short - the kind of column or parameter, as follows:
   • DatabaseMetaData.procedureColumnUnknown - type unknown
   • DatabaseMetaData.procedureColumnIn - an IN parameter
   • DatabaseMetaData.procedureColumnInOut - an INOUT parameter
   • DatabaseMetaData.procedureColumnOut - an OUT parameter
   • DatabaseMetaData.procedureColumnReturn - a return value
   • DatabaseMetaData.procedureReturnsResult - a result column in a result set
6. DATA_TYPE - int - the SQL type of the data, as in java.sql.Types
7. TYPE_NAME - String - the SQL type name, for a UDT it is fully qualified
8. PRECISION - int - the precision
9. LENGTH - int - the length of the data in bytes
10. SCALE - short - the scale for numeric types
11. RADIX - short - the Radix for numeric data (typically 2 or 10)
12. NULLABLE - short - can the data contain null:
    • DatabaseMetaData.procedureNoNulls - NULLs not permitted
    • DatabaseMetaData.procedureNullable - NULLs are permitted
    • DatabaseMetaData.procedureNullableUnknown - NULL status unknown
13. REMARKS - String - an explanatory comment about the data item

Returns the database vendor's preferred name for "procedure".

Returns a list of the stored procedures available in a specified catalog.

The list is returned as a ResultSet with one row for each stored procedure, ordered by PROCEDURE_SCHEME and PROCEDURE_NAME, with the data in each row as follows:

1. PROCEDURE_CAT - String : the procedure catalog name
2. PROCEDURE_SCHEM - String : the procedure schema name (possibly null)
3. PROCEDURE_NAME - String : the procedure name
4. Reserved
5. Reserved
6. Reserved
7. REMARKS - String - information about the procedure
8. PROCEDURE_TYPE - short : one of:
   • DatabaseMetaData.procedureResultUnknown - procedure may return a result
   • DatabaseMetaData.procedureNoResult - procedure does not return a result
   • DatabaseMetaData.procedureReturnsResult - procedure definitely returns a result

Returns the result set's default hold-ability.

Returns a list of all the SQL keywords that are NOT also SQL92 keywords for the database.

States the type of SQLState value returned by SQLException.getSQLState. This can either be the X/Open (now known as Open Group) SQL CLI form or the SQL99 form.

Returns the database vendor's preferred term for "schema".

Returns a list of the schema names in the database. The list is returned as a ResultSet, ordered by the Schema name, with one row per Schema in the following format:

1. TABLE_SCHEM - String - the Schema name
2. TABLE_CATALOG - String - the Catalog name (possibly null)

Returns the string that is used to escape wildcard characters. This string is used to escape the '_' and '%' wildcard characters in catalog search strings which are a pattern and so which use the wildcard characters. '_' is used to represent any single character wile '%' is used for a sequence of zero or more characters.

Returns a list of string functions available with the database. These functions are used in JDBC function escape clause and follow the Open Group CLI string function names definition.

Returns a listing of the hierarchies of tables in a specified schema in the database.

The listing only contains entries for tables that have a super table. Super and sub tables must be defined in the same Catalog and Schema. The list is returned as a ResultSet, with one row for each table that has a super table, in the following format:

1. TABLE_CAT - String - table catalog name (possibly null)
2. TABLE_SCHEM - String - Table Schema name (possibly null)
3. TABLE_NAME - String - The Table name
4. SUPERTABLE_NAME - String - The Super Table name

Returns the User Defined Type (UDT) hierarchies for a given schema. Only the immediate parent/child relationship is described. If a UDT does not have a direct supertype, it is not listed.

The listing is returned as a ResultSet where there is one row for a specific UDT which describes its supertype, with the data organized in columns as follows:

1. TYPE_CAT - String - the UDT Catalog name (possibly null)
2. TYPE_SCHEM - String - the UDT Schema name (possibly null)
3. TYPE_NAME - String - the UDT type name
4. SUPERTYPE_CAT - String - direct supertype's Catalog name (possibly null)
5. SUPERTYPE_SCHEM - String - direct supertype's Schema name (possibly null)
6. SUPERTYPE_NAME - String - direct supertype's name

Returns a list of system functions available with the database. These are names used in the JDBC function escape clause and are Open Group CLI function names.

Returns a description of access rights for each table present in a catalog. Table privileges can apply to one or more columns in the table - but are not guaranteed to apply to all columns.

The privileges are returned as a ResultSet, with one row for each privilege, ordered by TABLE_SCHEM, TABLE_NAME, PRIVILEGE, and each row has data as defined in the following column definitions:

1. TABLE_CAT - String - table catalog name (possibly null)
2. TABLE_SCHEM - String - Table Schema name (possibly null)
3. TABLE_NAME - String - The Table name
4. GRANTOR - String - who granted the access
5. GRANTEE - String - who received the access grant
6. PRIVILEGE - String - the type of access granted - one of SELECT, INSERT, UPDATE, REFERENCES,...
7. IS_GRANTABLE - String - "YES" implies the grantee can grant access to others, "NO" implies guarantee cannot grant access to others, null means this status is unknown

Returns a list of table types supported by the database.

The list is returned as a ResultSet with one row per table type, ordered by the table type. The information in the ResultSet is structured into a single column per row, as follows:

1. TABLE_TYPE - String - the Table Type. Typical names include "TABLE", "VIEW", "SYSTEM TABLE", "ALIAS", "SYNONYM", "GLOBAL TEMPORARY"

Returns a description of the tables in a specified catalog.

The descriptions are returned as rows in a ResultSet, one row for each Table. The ResultSet is ordered by TABLE_TYPE, TABLE_SCHEM and TABLE_NAME. Each row in the ResultSet consists of a series of columns as follows:

1. TABLE_CAT - String - table catalog name (possibly null)
2. TABLE_SCHEM - String - Table Schema name (possibly null)
3. TABLE_NAME - String - The Table name
4. TABLE_TYPE - String - Typical names include "TABLE", "VIEW", "SYSTEM TABLE", "ALIAS", "SYNONYM", "GLOBAL TEMPORARY"
5. REMARKS - String - A comment describing the table
6. TYPE_CAT - String - the 'Types' catalog(possibly null)
7. TYPE_SCHEM - String - the 'Types' schema(possibly null)
8. TYPE_NAME - String - the 'Types' name (possibly null)
9. SELF_REFERENCING_COL_NAME - String - the name of a designated identifier column in a typed table (possibly null)
10. REF_GENERATION - String - one of the following values : "SYSTEM" | "USER" | "DERIVED" - specifies how values in the SELF_REFERENCING_COL_NAME are created (possibly null)

Returns a list of time and date functions available for the database.

Get a list of the standard SQL Types supported by this database. The list is returned as a ResultSet, with one row for each type, ordered by the DATA_TYPE value, where the data in each row is structured into the following columns:

1. TYPE_NAMR - String : the Type name
2. DATA_TYPE - int : the SQL data type value as defined in java.sql.Types
3. PRECISION - int - the maximum precision of the type
4. LITERAL_PREFIX - String : the prefix to be used when quoting a literal value (possibly null)
5. LITERAL_SUFFIX - String : the suffix to be used when quoting a literal value (possibly null)
6. CREATE_PARAMS - String : params used when creating the type (possibly null)
7. NULLABLE - short : shows if the value is null-able:
   • DatabaseMetaData.typeNoNulls : NULLs not permitted
   • DatabaseMetaData.typeNullable : NULLs are permitted
   • DatabaseMetaData.typeNullableUnknown : NULL status unknown
8. CASE_SENSITIVE - boolean : true if the type is case sensitive
9. SEARCHABLE - short : how this type can be used with WHERE clauses:
   • DatabaseMetaData.typePredNone - cannot be used
   • DatabaseMetaData.typePredChar - support for WHERE...LIKE only
   • DatabaseMetaData.typePredBasic - support except for WHERE...LIKE
   • DatabaseMetaData.typeSearchable - support for all WHERE clauses
10. UNSIGNED_ATTRIBUTE - boolean - the type is unsigned or not
11. FIXED_PREC_SCALE - boolean - fixed precision = it can be used as a money value
12. AUTO_INCREMENT - boolean - can be used as an auto-increment value
13. LOCAL_TYPE_NAME - String - a localized version of the type name (possibly null)
14. MINIMUM_SCALE - short - the minimum scale supported
15. MAXIMUM_SCALE - short - the maximum scale supported
16. SQL_DATA_TYPE - int - not used
17. SQL_DATETIME_SUB - int - not used
18. NUM_PREC_RADIX - int - number radix (typically 2 or 10)

Returns a description of the User Defined Types (UDTs) defined in a given schema, which includes the types DISTINCT, STRUCT and JAVA_OBJECT.

The types matching the supplied the specified Catalog, Schema, Type Name and Type are returned as rows in a ResultSet with columns of information as follows:

1. TABLE_CAT - String - Catalog name (possibly null)
2. TABLE_SCHEM - String - Schema name (possibly null)
3. TABLE_NAME - String - The Table name
4. CLASS_NAME - String - The Java class name
5. DATA_TYPE - int - The SQL type as specified in java.sql.Types. One of DISTINCT, STRUCT and JAVA_OBJECT
6. REMARKS - String - A comment which describes the type
7. BASE_TYPE - short - A type code. For a DISTINCT type, the source type. For a structured type this is the type that implements the user generated reference type of the SELF_REFERENCING_COLUMN. This is defined in java.sql.Types, and will be null if the DATA_TYPE does not match these criteria.

Returns the URL for this database.

Determine the user name as known by the database.

Returns which of a table's columns are automatically updated when any value in a row is updated.

The result is laid-out in the following columns:

1. SCOPE - short - not used
2. COLUMN_NAME - String - Column name
3. DATA_TYPE - int - The SQL data type, as defined in java.sql.Types
4. TYPE_NAME - String - The SQL type name, data source dependent
5. COLUMN_SIZE - int - Precision for numeric types
6. BUFFER_LENGTH - int - Length of a column value in bytes
7. DECIMAL_DIGITS - short - Number of digits after the decimal point
8. PSEUDO_COLUMN - short - If this is a pseudo-column (for example, an Oracle ROWID):
   • DatabaseMetaData.bestRowUnknown - don't know whether this is a pseudo column
   • DatabaseMetaData.bestRowNotPseudo - column is not pseudo
   • DatabaseMetaData.bestRowPseudo - column is a pseudo column

Determine if a visible row insert can be detected by calling ResultSet.rowInserted.

Determine whether a fully qualified table name is prefixed or suffixed to a fully qualified table name.

Determine if the database is in read-only mode.

Determine if updates are made to a copy of, or directly on, Large Objects (LOBs).

Determine if the database handles concatenations between NULL and non-NULL values by producing a NULL output.

Determine if NULL values are always sorted to the end of sorted results regardless of requested sort order. This means that they will appear at the end of sorted lists whatever other non-NULL values may be present.

Determine if NULL values are always sorted at the start of the sorted list, irrespective of the sort order. This means that they appear at the start of sorted lists, whatever other values may be present.

Determine if NULL values are sorted high - i.e. they are sorted as if they are higher than any other values.

Determine if NULL values are sorted low - ie they are sorted as if they are lower than any other values.

Determine if deletes made by others are visible, for a specified ResultSet type.

Determine if inserts made by others are visible, for a specified ResultSet type.

Determine if updates made by others are visible, for a specified ResultSet type.

Determine if a ResultSet's own deletes are visible, for a specified ResultSet type.

Determine if its own inserts are visible to a given ResultSet type.

Determine if for a supplied type of ResultSet, the ResultSet's own updates are visible.

Determine whether the database treats SQL identifiers that are in mixed case (and unquoted) as case insensitive. If true then the database stores them in lower case.

Determine whether the database considers mixed case quoted SQL identifiers as case insensitive and stores them in lower case.

Determine whether the database considers mixed case unquoted SQL identifiers as case insensitive and stores them in mixed case.

Determine whether the database considers identifiers as case insensitive if they are mixed case quoted SQL. The database stores them in mixed case.

Determine whether the database considers mixed case unquoted SQL identifiers as case insensitive and stores them in upper case.

Determine whether the database considers mixed case quoted SQL identifiers as case insensitive and stores them in upper case.

Determine if the database supports the ANSI92 entry level SQL grammar.

Determine if the database supports the ANSI92 full SQL grammar.

Determine if the database supports the ANSI92 intermediate SQL Grammar.

Determine if the database supports ALTER TABLE operation with add column.

Determine if the database supports ALTER TABLE operation with drop column.

Determine if the database supports Batch Updates.

Determine whether catalog names may be used in data manipulation statements.

Determine if catalog names can be used in Index Definition statements.

Determine if catalog names can be used in privilege definition statements.

Determine if catalog names can be used in procedure call statements.

Determine if catalog names may be used in table definition statements.

Determine if the database supports column aliasing.

If aliasing is supported, then the SQL AS clause is used to provide names for computed columns and provide alias names for columns.

Determine if the database supports CONVERT operation for two supplied SQL types.

Determine if the database supports the CONVERT operation between SQL types.

Determine if the database supports the Core SQL Grammar for ODBC.

Determine if the database supports correlated sub-queries.

Determine if the database allows both data definition and data manipulation statements inside a transaction.

Determine if the database only allows data manipulation statements inside a transaction.

Determine if table correlation names are restricted to be different from the names of the tables, when they are supported.

Determine whether expressions in ORDER BY lists are supported.

Determine whether the Extended SQL Grammar for ODBC is supported.

Determine if the database supports full nested outer joins.

Determine if auto generated keys can be returned when a statement executes.

Determine if the database supports a form of GROUP BY clause.

Determine if the database supports using a column name in a GROUP BY clause not included in the SELECT statement as long as all of the columns in the SELECT statement are used in the GROUP BY clause.

Determine if the database supports using a column name in a GROUP BY clause that is not in the SELECT statement.

Determine whether the database supports SQL Integrity Enhancement Facility.

Determine if the database supports using a LIKE escape clause.

Determine if the database provides limited support for outer Join operations.

Determine if the database supports Minimum SQL Grammar for ODBC.

Determine if the database treats mixed case unquoted SQL identifiers as case sensitive storing them in mixed case.

Determine whether the database considers mixed case quoted SQL identifiers as case sensitive, storing them in mixed case.

Determine if it is possible for a single CallableStatement to return multiple ResultSets simultaneously.

Determine whether retrieving multiple ResultSets from a single call to the execute method is supported.

Determine whether multiple transactions in progress at at time on different connections are supported.

Determine whether call-able statements with named parameters is supported.

Determine if columns in the database can be defined as non-nullable.

Determine whether keeping Cursors open across Commit operations is supported.

Determine if the database can keep Cursors open across Rollback operations.

Determine whether keeping Statements open across Commit operations is supported.

Determine whether keeping Statements open across Rollback operations is supported.

Determine whether using a column in an ORDER BY clause that is not in the SELECT statement is supported.

Determine whether outer join operations are supported.

Determine whether positioned DELETE statements are supported.

Determine whether positioned UPDATE statements are supported.

Determine whether there is support for a given concurrency style for the given ResultSet.

Determine whether the supplied ResultSet holdability is supported.

Determine whether the supplied ResultSet type is supported.

Determine whether Savepoints for transactions are supported.

Determine whether a schema name may be used in a data manipulation statement.

Determine whether a schema name may be used in an index definition statement.

Determine whether a database schema name can be used in a privilege definition statement.

Determine if a procedure call statement may be contain in a schema name.

Determine if a schema name can be used in a table definition statement.

Determine if this SELECT FOR UPDATE statements ar supported.

Determine whether statement pooling is supported.

Determine whether stored procedure calls using the stored procedure escape syntax is supported.

Determine whether subqueries in comparison expressions are supported.

Determine whether subqueries in EXISTS expressions are supported.

Determine whether subqueries in IN statements are supported.

Determine whether subqueries in quantified expressions are supported.

Determine whether the database has table correlation names support.

Determine whether a specified transaction isolation level is supported.

Determine whether transactions are supported.

If transactions are not supported, then the commit method does nothing and the transaction isolation level is always TRANSACTION_NONE.

Determine whether the SQL UNION operation is supported.

Determine whether the SQL UNION ALL operation is supported.

Determine if the method ResultSet.rowUpdated can detect a visible row update.

Determine if this database uses a file for each table.

Determine whether this database uses a local file to store tables.