Example usage for Java java.sql DatabaseMetaData fields, constructors, methods, implement or subclass
The text is from its open source code.
int | procedureResultUnknown Indicates that it is not known whether the procedure returns a result. |
int | procedureNoResult Indicates that the procedure does not return a result. |
int | procedureReturnsResult Indicates that the procedure returns a result. |
int | procedureColumnUnknown Indicates that type of the column is unknown. |
int | procedureColumnIn Indicates that the column stores IN parameters. |
int | procedureColumnInOut Indicates that the column stores INOUT parameters. |
int | procedureColumnOut Indicates that the column stores OUT parameters. |
int | procedureColumnReturn Indicates that the column stores return values. |
int | procedureColumnResult Indicates that the column stores results. |
int | procedureNoNulls Indicates that NULL values are not allowed. |
int | procedureNullable Indicates that NULL values are allowed. |
int | columnNoNulls Indicates that the column might not allow NULL values. |
int | columnNullable Indicates that the column definitely allows NULL values. |
int | columnNullableUnknown Indicates that the nullability of columns is unknown. |
int | bestRowTemporary Indicates that the scope of the best row identifier is very temporary, lasting only while the row is being used. |
int | bestRowSession Indicates that the scope of the best row identifier is the remainder of the current session. |
int | bestRowNotPseudo Indicates that the best row identifier is NOT a pseudo column. |
int | versionColumnNotPseudo Indicates that this version column is NOT a pseudo column. |
int | versionColumnPseudo Indicates that this version column is a pseudo column. |
int | importedKeyCascade For the column UPDATE_RULE , indicates that when the primary key is updated, the foreign key (imported key) is changed to agree with it. |
int | importedKeyRestrict For the column UPDATE_RULE , indicates that a primary key may not be updated if it has been imported by another table as a foreign key. |
int | importedKeySetNull For the columns UPDATE_RULE and DELETE_RULE , indicates that when the primary key is updated or deleted, the foreign key (imported key) is changed to NULL . |
int | importedKeyNoAction For the columns UPDATE_RULE and DELETE_RULE , indicates that if the primary key has been imported, it cannot be updated or deleted. |
int | importedKeySetDefault For the columns UPDATE_RULE and DELETE_RULE , indicates that if the primary key is updated or deleted, the foreign key (imported key) is set to the default value. |
int | importedKeyInitiallyDeferred Indicates deferrability. |
int | importedKeyInitiallyImmediate Indicates deferrability. |
int | importedKeyNotDeferrable Indicates deferrability. |
int | typeNoNulls Indicates that a NULL value is NOT allowed for this data type. |
int | typeNullable Indicates that a NULL value is allowed for this data type. |
int | typeSearchable Indicates that all WHERE search clauses can be based on this type. |
short | tableIndexStatistic Indicates that this column contains table statistics that are returned in conjunction with a table's index descriptions. |
short | tableIndexClustered Indicates that this table index is a clustered index. |
short | tableIndexHashed Indicates that this table index is a hashed index. |
short | tableIndexOther Indicates that this table index is not a clustered index, a hashed index, or table statistics; it is something other than these. |
short | attributeNoNulls Indicates that NULL values might not be allowed. |
short | attributeNullable Indicates that NULL values are definitely allowed. |
short | attributeNullableUnknown Indicates that whether NULL values are allowed is not known. |
int | sqlStateXOpen A possible return value for the method DatabaseMetaData.getSQLStateType which is used to indicate whether the value returned by the method SQLException.getSQLState is an X/Open (now know as Open Group) SQL CLI SQLSTATE value. |
int | sqlStateSQL A possible return value for the method DatabaseMetaData.getSQLStateType which is used to indicate whether the value returned by the method SQLException.getSQLState is an SQLSTATE value. |
int | sqlStateSQL99 A possible return value for the method DatabaseMetaData.getSQLStateType which is used to indicate whether the value returned by the method SQLException.getSQLState is an SQL99 SQLSTATE value. |
boolean | allProceduresAreCallable() Retrieves whether the current user can call all the procedures returned by the method getProcedures . |
boolean | allTablesAreSelectable() Retrieves whether the current user can use all the tables returned by the method getTables in a SELECT statement. |
boolean | dataDefinitionCausesTransactionCommit() Retrieves whether a data definition statement within a transaction forces the transaction to commit. |
boolean | dataDefinitionIgnoredInTransactions() Retrieves whether this database ignores a data definition statement within a transaction. |
boolean | doesMaxRowSizeIncludeBlobs() Retrieves whether the return value for the method getMaxRowSize includes the SQL data types LONGVARCHAR and LONGVARBINARY . |
boolean | equals(Object obj) Indicates whether some other object is "equal to" this one. |
ResultSet | getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable) Retrieves a description of a table's optimal set of columns that uniquely identifies a row. |
ResultSet | getCatalogs() Retrieves the catalog names available in this database. |
String | getCatalogSeparator() Retrieves the String that this database uses as the separator between a catalog and table name. |
String | getCatalogTerm() Retrieves the database vendor's preferred term for "catalog". |
Class> | getClass() Returns the runtime class of this Object . |
ResultSet | getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern) Retrieves a description of the access rights for a table's columns. |
ResultSet | getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) Retrieves a description of table columns available in the specified catalog. |
Connection | getConnection() Retrieves the connection that produced this metadata object. |
ResultSet | getCrossReference(String parentCatalog, String parentSchema, String parentTable, String foreignCatalog, String foreignSchema, String foreignTable) Retrieves a description of the foreign key columns in the given foreign key table that reference the primary key or the columns representing a unique constraint of the parent table (could be the same or a different table). |
int | getDatabaseMajorVersion() Retrieves the major version number of the underlying database. |
int | getDatabaseMinorVersion() Retrieves the minor version number of the underlying database. |
String | getDatabaseProductName() Retrieves the name of this database product. |
String | getDatabaseProductVersion() Retrieves the version number of this database product. |
int | getDefaultTransactionIsolation() Retrieves this database's default transaction isolation level. |
int | getDriverMajorVersion() Retrieves this JDBC driver's major version number. |
int | getDriverMinorVersion() Retrieves this JDBC driver's minor version number. |
String | getDriverName() Retrieves the name of this JDBC driver. |
String | getDriverVersion() Retrieves the version number of this JDBC driver as a String . |
ResultSet | getExportedKeys(String catalog, String schema, String table) Retrieves a description of the foreign key columns that reference the given table's primary key columns (the foreign keys exported by a table). |
String | getExtraNameCharacters() Retrieves all the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _). |
ResultSet | getFunctionColumns(String catalog, String schemaPattern, String functionNamePattern, String columnNamePattern) Retrieves a description of the given catalog's system or user function parameters and return type. |
ResultSet | getFunctions(String catalog, String schemaPattern, String functionNamePattern) Retrieves a description of the system and user functions available in the given catalog. |
String | getIdentifierQuoteString() Retrieves the string used to quote SQL identifiers. |
ResultSet | getImportedKeys(String catalog, String schema, String table) Retrieves a description of the primary key columns that are referenced by the given table's foreign key columns (the primary keys imported by a table). |
ResultSet | getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate) Retrieves a description of the given table's indices and statistics. |
int | getJDBCMajorVersion() Retrieves the major JDBC version number for this driver. |
int | getJDBCMinorVersion() Retrieves the minor JDBC version number for this driver. |
int | getMaxBinaryLiteralLength() Retrieves the maximum number of hex characters this database allows in an inline binary literal. |
int | getMaxCatalogNameLength() Retrieves the maximum number of characters that this database allows in a catalog name. |
int | getMaxCharLiteralLength() Retrieves the maximum number of characters this database allows for a character literal. |
int | getMaxColumnNameLength() Retrieves the maximum number of characters this database allows for a column name. |
int | getMaxColumnsInGroupBy() Retrieves the maximum number of columns this database allows in a GROUP BY clause. |
int | getMaxColumnsInIndex() Retrieves the maximum number of columns this database allows in an index. |
int | getMaxColumnsInOrderBy() Retrieves the maximum number of columns this database allows in an ORDER BY clause. |
int | getMaxColumnsInSelect() Retrieves the maximum number of columns this database allows in a SELECT list. |
int | getMaxColumnsInTable() Retrieves the maximum number of columns this database allows in a table. |
int | getMaxConnections() Retrieves the maximum number of concurrent connections to this database that are possible. |
int | getMaxCursorNameLength() Retrieves the maximum number of characters that this database allows in a cursor name. |
int | getMaxIndexLength() Retrieves the maximum number of bytes this database allows for an index, including all of the parts of the index. |
int | getMaxProcedureNameLength() Retrieves the maximum number of characters that this database allows in a procedure name. |
int | getMaxRowSize() Retrieves the maximum number of bytes this database allows in a single row. |
int | getMaxSchemaNameLength() Retrieves the maximum number of characters that this database allows in a schema name. |
int | getMaxStatementLength() Retrieves the maximum number of characters this database allows in an SQL statement. |
int | getMaxStatements() Retrieves the maximum number of active statements to this database that can be open at the same time. |
int | getMaxTableNameLength() Retrieves the maximum number of characters this database allows in a table name. |
int | getMaxTablesInSelect() Retrieves the maximum number of tables this database allows in a SELECT statement. |
int | getMaxUserNameLength() Retrieves the maximum number of characters this database allows in a user name. |
String | getNumericFunctions() Retrieves a comma-separated list of math functions available with this database. |
ResultSet | getPrimaryKeys(String catalog, String schema, String table) Retrieves a description of the given table's primary key columns. |
ResultSet | getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) Retrieves a description of the given catalog's stored procedure parameter and result columns. |
ResultSet | getProcedures(String catalog, String schemaPattern, String procedureNamePattern) Retrieves a description of the stored procedures available in the given catalog. |
String | getProcedureTerm() Retrieves the database vendor's preferred term for "procedure". |
ResultSet | getPseudoColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) Retrieves a description of the pseudo or hidden columns available in a given table within the specified catalog and schema. |
int | getResultSetHoldability() Retrieves this database's default holdability for ResultSet objects. |
RowIdLifetime | getRowIdLifetime() Indicates whether this data source supports the SQL ROWID type, and the lifetime for which a RowId object remains valid. |
ResultSet | getSchemas() Retrieves the schema names available in this database. |
ResultSet | getSchemas(String catalog, String schemaPattern) Retrieves the schema names available in this database. |
String | getSchemaTerm() Retrieves the database vendor's preferred term for "schema". |
String | getSearchStringEscape() Retrieves the string that can be used to escape wildcard characters. |
String | getSQLKeywords() Retrieves a comma-separated list of all of this database's SQL keywords that are NOT also SQL:2003 keywords. |
int | getSQLStateType() Indicates whether the SQLSTATE returned by SQLException.getSQLState is X/Open (now known as Open Group) SQL CLI or SQL:2003. |
String | getStringFunctions() Retrieves a comma-separated list of string functions available with this database. |
String | getSystemFunctions() Retrieves a comma-separated list of system functions available with this database. |
ResultSet | getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern) Retrieves a description of the access rights for each table available in a catalog. |
ResultSet | getTables(String catalog, String schemaPattern, String tableNamePattern, String types[]) Retrieves a description of the tables available in the given catalog. |
ResultSet | getTableTypes() Retrieves the table types available in this database. |
String | getTimeDateFunctions() Retrieves a comma-separated list of the time and date functions available with this database. |
ResultSet | getTypeInfo() Retrieves a description of all the data types supported by this database. |
ResultSet | getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types) Retrieves a description of the user-defined types (UDTs) defined in a particular schema. |
String | getURL() Retrieves the URL for this DBMS. |
String | getUserName() Retrieves the user name as known to this database. |
ResultSet | getVersionColumns(String catalog, String schema, String table) Retrieves a description of a table's columns that are automatically updated when any value in a row is updated. |
boolean | insertsAreDetected(int type) Retrieves whether or not a visible row insert can be detected by calling the method ResultSet.rowInserted . |
boolean | isCatalogAtStart() Retrieves whether a catalog appears at the start of a fully qualified table name. |
boolean | isReadOnly() Retrieves whether this database is in read-only mode. |
boolean | nullPlusNonNullIsNull() Retrieves whether this database supports concatenations between NULL and non-NULL values being NULL . |
boolean | nullsAreSortedAtEnd() Retrieves whether NULL values are sorted at the end regardless of sort order. |
boolean | nullsAreSortedAtStart() Retrieves whether NULL values are sorted at the start regardless of sort order. |
boolean | nullsAreSortedHigh() Retrieves whether NULL values are sorted high. |
boolean | nullsAreSortedLow() Retrieves whether NULL values are sorted low. |
boolean | othersDeletesAreVisible(int type) Retrieves whether deletes made by others are visible. |
boolean | othersInsertsAreVisible(int type) Retrieves whether inserts made by others are visible. |
boolean | othersUpdatesAreVisible(int type) Retrieves whether updates made by others are visible. |
boolean | ownDeletesAreVisible(int type) Retrieves whether a result set's own deletes are visible. |
boolean | ownInsertsAreVisible(int type) Retrieves whether a result set's own inserts are visible. |
boolean | ownUpdatesAreVisible(int type) Retrieves whether for the given type of ResultSet object, the result set's own updates are visible. |
boolean | storesLowerCaseIdentifiers() Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in lower case. |
boolean | storesLowerCaseQuotedIdentifiers() Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in lower case. |
boolean | storesMixedCaseIdentifiers() Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in mixed case. |
boolean | storesMixedCaseQuotedIdentifiers() Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in mixed case. |
boolean | storesUpperCaseIdentifiers() Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in upper case. |
boolean | storesUpperCaseQuotedIdentifiers() Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in upper case. |
boolean | supportsAlterTableWithAddColumn() Retrieves whether this database supports ALTER TABLE with add column. |
boolean | supportsAlterTableWithDropColumn() Retrieves whether this database supports ALTER TABLE with drop column. |
boolean | supportsANSI92EntryLevelSQL() Retrieves whether this database supports the ANSI92 entry level SQL grammar. |
boolean | supportsANSI92FullSQL() Retrieves whether this database supports the ANSI92 full SQL grammar supported. |
boolean | supportsANSI92IntermediateSQL() Retrieves whether this database supports the ANSI92 intermediate SQL grammar supported. |
boolean | supportsBatchUpdates() Retrieves whether this database supports batch updates. |
boolean | supportsCatalogsInDataManipulation() Retrieves whether a catalog name can be used in a data manipulation statement. |
boolean | supportsCatalogsInIndexDefinitions() Retrieves whether a catalog name can be used in an index definition statement. |
boolean | supportsCatalogsInPrivilegeDefinitions() Retrieves whether a catalog name can be used in a privilege definition statement. |
boolean | supportsCatalogsInProcedureCalls() Retrieves whether a catalog name can be used in a procedure call statement. |
boolean | supportsCatalogsInTableDefinitions() Retrieves whether a catalog name can be used in a table definition statement. |
boolean | supportsColumnAliasing() Retrieves whether this database supports column aliasing. |
boolean | supportsConvert() Retrieves whether this database supports the JDBC scalar function CONVERT for the conversion of one JDBC type to another. |
boolean | supportsConvert(int fromType, int toType) Retrieves whether this database supports the JDBC scalar function CONVERT for conversions between the JDBC types fromType and toType. |
boolean | supportsCoreSQLGrammar() Retrieves whether this database supports the ODBC Core SQL grammar. |
boolean | supportsCorrelatedSubqueries() Retrieves whether this database supports correlated subqueries. |
boolean | supportsDataDefinitionAndDataManipulationTransactions() Retrieves whether this database supports both data definition and data manipulation statements within a transaction. |
boolean | supportsDataManipulationTransactionsOnly() Retrieves whether this database supports only data manipulation statements within a transaction. |
boolean | supportsDifferentTableCorrelationNames() Retrieves whether, when table correlation names are supported, they are restricted to being different from the names of the tables. |
boolean | supportsExpressionsInOrderBy() Retrieves whether this database supports expressions in ORDER BY lists. |
boolean | supportsExtendedSQLGrammar() Retrieves whether this database supports the ODBC Extended SQL grammar. |
boolean | supportsFullOuterJoins() Retrieves whether this database supports full nested outer joins. |
boolean | supportsGetGeneratedKeys() Retrieves whether auto-generated keys can be retrieved after a statement has been executed |
boolean | supportsGroupBy() Retrieves whether this database supports some form of GROUP BY clause. |
boolean | supportsGroupByBeyondSelect() Retrieves whether this database supports using columns not included in the SELECT statement in a GROUP BY clause provided that all of the columns in the SELECT statement are included in the GROUP BY clause. |
boolean | supportsGroupByUnrelated() Retrieves whether this database supports using a column that is not in the SELECT statement in a GROUP BY clause. |
boolean | supportsIntegrityEnhancementFacility() Retrieves whether this database supports the SQL Integrity Enhancement Facility. |
boolean | supportsLikeEscapeClause() Retrieves whether this database supports specifying a LIKE escape clause. |
boolean | supportsLimitedOuterJoins() Retrieves whether this database provides limited support for outer joins. |
boolean | supportsMinimumSQLGrammar() Retrieves whether this database supports the ODBC Minimum SQL grammar. |
boolean | supportsMixedCaseIdentifiers() Retrieves whether this database treats mixed case unquoted SQL identifiers as case sensitive and as a result stores them in mixed case. |
boolean | supportsMixedCaseQuotedIdentifiers() Retrieves whether this database treats mixed case quoted SQL identifiers as case sensitive and as a result stores them in mixed case. |
boolean | supportsMultipleOpenResults() Retrieves whether it is possible to have multiple ResultSet objects returned from a CallableStatement object simultaneously. |
boolean | supportsMultipleResultSets() Retrieves whether this database supports getting multiple ResultSet objects from a single call to the method execute . |
boolean | supportsMultipleTransactions() Retrieves whether this database allows having multiple transactions open at once (on different connections). |
boolean | supportsNamedParameters() Retrieves whether this database supports named parameters to callable statements. |
boolean | supportsNonNullableColumns() Retrieves whether columns in this database may be defined as non-nullable. |
boolean | supportsOpenCursorsAcrossCommit() Retrieves whether this database supports keeping cursors open across commits. |
boolean | supportsOpenCursorsAcrossRollback() Retrieves whether this database supports keeping cursors open across rollbacks. |
boolean | supportsOpenStatementsAcrossCommit() Retrieves whether this database supports keeping statements open across commits. |
boolean | supportsOpenStatementsAcrossRollback() Retrieves whether this database supports keeping statements open across rollbacks. |
boolean | supportsOrderByUnrelated() Retrieves whether this database supports using a column that is not in the SELECT statement in an ORDER BY clause. |
boolean | supportsOuterJoins() Retrieves whether this database supports some form of outer join. |
boolean | supportsPositionedDelete() Retrieves whether this database supports positioned DELETE statements. |
boolean | supportsPositionedUpdate() Retrieves whether this database supports positioned UPDATE statements. |
boolean | supportsResultSetConcurrency(int type, int concurrency) Retrieves whether this database supports the given concurrency type in combination with the given result set type. |
boolean | supportsResultSetHoldability(int holdability) Retrieves whether this database supports the given result set holdability. |
boolean | supportsResultSetType(int type) Retrieves whether this database supports the given result set type. |
boolean | supportsSavepoints() Retrieves whether this database supports savepoints. |
boolean | supportsSchemasInDataManipulation() Retrieves whether a schema name can be used in a data manipulation statement. |
boolean | supportsSchemasInIndexDefinitions() Retrieves whether a schema name can be used in an index definition statement. |
boolean | supportsSchemasInPrivilegeDefinitions() Retrieves whether a schema name can be used in a privilege definition statement. |
boolean | supportsSchemasInProcedureCalls() Retrieves whether a schema name can be used in a procedure call statement. |
boolean | supportsSchemasInTableDefinitions() Retrieves whether a schema name can be used in a table definition statement. |
boolean | supportsSelectForUpdate() Retrieves whether this database supports SELECT FOR UPDATE statements. |
boolean | supportsStatementPooling() Retrieves whether this database supports statement pooling. |
boolean | supportsStoredFunctionsUsingCallSyntax() Retrieves whether this database supports invoking user-defined or vendor functions using the stored procedure escape syntax. |
boolean | supportsStoredProcedures() Retrieves whether this database supports stored procedure calls that use the stored procedure escape syntax. |
boolean | supportsSubqueriesInComparisons() Retrieves whether this database supports subqueries in comparison expressions. |
boolean | supportsSubqueriesInExists() Retrieves whether this database supports subqueries in EXISTS expressions. |
boolean | supportsSubqueriesInIns() Retrieves whether this database supports subqueries in IN expressions. |
boolean | supportsSubqueriesInQuantifieds() Retrieves whether this database supports subqueries in quantified expressions. |
boolean | supportsTableCorrelationNames() Retrieves whether this database supports table correlation names. |
boolean | supportsTransactionIsolationLevel(int level) Retrieves whether this database supports the given transaction isolation level. |
boolean | supportsTransactions() Retrieves whether this database supports transactions. |
boolean | supportsUnion() Retrieves whether this database supports SQL UNION . |
boolean | supportsUnionAll() Retrieves whether this database supports SQL UNION ALL . |
boolean | updatesAreDetected(int type) Retrieves whether or not a visible row update can be detected by calling the method ResultSet.rowUpdated . |
boolean | usesLocalFilePerTable() Retrieves whether this database uses a file for each table. |
boolean | usesLocalFiles() Retrieves whether this database stores tables in a local file. |