Participer au site avec un Tip
Rechercher
 

Améliorations / Corrections

Vous avez des améliorations (ou des corrections) à proposer pour ce document : je vous remerçie par avance de m'en faire part, cela m'aide à améliorer le site.

Emplacement :

Description des améliorations :

Module : java.sql - Package : java.sql
Version documentée : Java SE 17

Interface « DatabaseMetaData »

Informations générales

Liste des attributs

Tous les attributs Attributs d'instance Attributs statiques Attributs dépréciés
QualificateursTypeNomDescription
public static short attributeNoNulls
public static short attributeNullable
public static short attributeNullableUnknown
public static int bestRowNotPseudo
public static int bestRowPseudo
public static int bestRowSession
public static int bestRowTemporary
public static int bestRowTransaction
public static int bestRowUnknown
public static int columnNoNulls
public static int columnNullable
public static int columnNullableUnknown
public static int functionColumnIn
public static int functionColumnInOut
public static int functionColumnOut
public static int functionColumnResult
public static int functionColumnUnknown
public static int functionNoNulls
public static int functionNoTable
public static int functionNullable
public static int functionNullableUnknown
public static int functionResultUnknown
public static int functionReturn
public static int functionReturnsTable
public static int importedKeyCascade
public static int importedKeyInitiallyDeferred
public static int importedKeyInitiallyImmediate
public static int importedKeyNoAction
public static int importedKeyNotDeferrable
public static int importedKeyRestrict
public static int importedKeySetDefault
public static int importedKeySetNull
public static int procedureColumnIn
public static int procedureColumnInOut
public static int procedureColumnOut
public static int procedureColumnResult
public static int procedureColumnReturn
public static int procedureColumnUnknown
public static int procedureNoNulls
public static int procedureNoResult
public static int procedureNullable
public static int procedureNullableUnknown
public static int procedureResultUnknown
public static int procedureReturnsResult
public static int sqlStateSQL
public static int sqlStateSQL99
public static int sqlStateXOpen
public static short tableIndexClustered
public static short tableIndexHashed
public static short tableIndexOther
public static short tableIndexStatistic
public static int typeNoNulls
public static int typeNullable
public static int typeNullableUnknown
public static int typePredBasic
public static int typePredChar
public static int typePredNone
public static int typeSearchable
public static int versionColumnNotPseudo
public static int versionColumnPseudo
public static int versionColumnUnknown

Liste des constructeurs

Constructeurs Constructeurs dépréciés
ConstructeurDescription

Liste des méthodes

Toutes les méthodes Méthodes d'instance Méthodes statiques Méthodes concrètes Méthodes abstraites Méthodes dépréciées
QualificateursType de retourPrototype de la méthodeDescription
public abstract boolean allProceduresAreCallable()
public abstract boolean allTablesAreSelectable()
public abstract boolean autoCommitFailureClosesAllResultSets()
public abstract boolean dataDefinitionCausesTransactionCommit()
public abstract boolean dataDefinitionIgnoredInTransactions()
public abstract boolean deletesAreDetected( int type )
public abstract boolean doesMaxRowSizeIncludeBlobs()
public abstract boolean generatedKeyAlwaysReturned()
public abstract ResultSet getAttributes( String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern )
public abstract ResultSet getBestRowIdentifier( String catalog, String schema, String table, int scope, boolean nullable )
public abstract ResultSet getCatalogs()
public abstract String getCatalogSeparator()
public abstract String getCatalogTerm()
public abstract ResultSet getClientInfoProperties()
public abstract ResultSet getColumnPrivileges( String catalog, String schema, String table, String columnNamePattern )
public abstract ResultSet getColumns( String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern )
public abstract Connection getConnection()
public abstract ResultSet getCrossReference( String parentCatalog, String parentSchema, String parentTable, String foreignCatalog, String foreignSchema, String foreignTable )
public abstract int getDatabaseMajorVersion()
public abstract int getDatabaseMinorVersion()
public abstract String getDatabaseProductName()
public abstract String getDatabaseProductVersion()
public abstract int getDefaultTransactionIsolation()
public abstract int getDriverMajorVersion()
public abstract int getDriverMinorVersion()
public abstract String getDriverName()
public abstract String getDriverVersion()
public abstract ResultSet getExportedKeys( String catalog, String schema, String table )
public abstract String getExtraNameCharacters()
public abstract ResultSet getFunctionColumns( String catalog, String schemaPattern, String functionNamePattern, String columnNamePattern )
public abstract ResultSet getFunctions( String catalog, String schemaPattern, String functionNamePattern )
public abstract String getIdentifierQuoteString()
public abstract ResultSet getImportedKeys( String catalog, String schema, String table )
public abstract ResultSet getIndexInfo( String catalog, String schema, String table, boolean unique, boolean approximate )
public abstract int getJDBCMajorVersion()
public abstract int getJDBCMinorVersion()
public abstract int getMaxBinaryLiteralLength()
public abstract int getMaxCatalogNameLength()
public abstract int getMaxCharLiteralLength()
public abstract int getMaxColumnNameLength()
public abstract int getMaxColumnsInGroupBy()
public abstract int getMaxColumnsInIndex()
public abstract int getMaxColumnsInOrderBy()
public abstract int getMaxColumnsInSelect()
public abstract int getMaxColumnsInTable()
public abstract int getMaxConnections()
public abstract int getMaxCursorNameLength()
public abstract int getMaxIndexLength()
public default long getMaxLogicalLobSize()
public abstract int getMaxProcedureNameLength()
public abstract int getMaxRowSize()
public abstract int getMaxSchemaNameLength()
public abstract int getMaxStatementLength()
public abstract int getMaxStatements()
public abstract int getMaxTableNameLength()
public abstract int getMaxTablesInSelect()
public abstract int getMaxUserNameLength()
public abstract String getNumericFunctions()
public abstract ResultSet getPrimaryKeys( String catalog, String schema, String table )
public abstract ResultSet getProcedureColumns( String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern )
public abstract ResultSet getProcedures( String catalog, String schemaPattern, String procedureNamePattern )
public abstract String getProcedureTerm()
public abstract ResultSet getPseudoColumns( String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern )
public abstract int getResultSetHoldability()
public abstract RowIdLifetime getRowIdLifetime()
public abstract ResultSet getSchemas( String catalog, String schemaPattern )
public abstract ResultSet getSchemas()
public abstract String getSchemaTerm()
public abstract String getSearchStringEscape()
public abstract String getSQLKeywords()
public abstract int getSQLStateType()
public abstract String getStringFunctions()
public abstract ResultSet getSuperTables( String catalog, String schemaPattern, String tableNamePattern )
public abstract ResultSet getSuperTypes( String catalog, String schemaPattern, String typeNamePattern )
public abstract String getSystemFunctions()
public abstract ResultSet getTablePrivileges( String catalog, String schemaPattern, String tableNamePattern )
public abstract ResultSet getTables( String catalog, String schemaPattern, String tableNamePattern, String[] types )
public abstract ResultSet getTableTypes()
public abstract String getTimeDateFunctions()
public abstract ResultSet getTypeInfo()
public abstract ResultSet getUDTs( String catalog, String schemaPattern, String typeNamePattern, int[] types )
public abstract String getURL()
public abstract String getUserName()
public abstract ResultSet getVersionColumns( String catalog, String schema, String table )
public abstract boolean insertsAreDetected( int type )
public abstract boolean isCatalogAtStart()
public abstract boolean isReadOnly()
public abstract boolean locatorsUpdateCopy()
public abstract boolean nullPlusNonNullIsNull()
public abstract boolean nullsAreSortedAtEnd()
public abstract boolean nullsAreSortedAtStart()
public abstract boolean nullsAreSortedHigh()
public abstract boolean nullsAreSortedLow()
public abstract boolean othersDeletesAreVisible( int type )
public abstract boolean othersInsertsAreVisible( int type )
public abstract boolean othersUpdatesAreVisible( int type )
public abstract boolean ownDeletesAreVisible( int type )
public abstract boolean ownInsertsAreVisible( int type )
public abstract boolean ownUpdatesAreVisible( int type )
public abstract boolean storesLowerCaseIdentifiers()
public abstract boolean storesLowerCaseQuotedIdentifiers()
public abstract boolean storesMixedCaseIdentifiers()
public abstract boolean storesMixedCaseQuotedIdentifiers()
public abstract boolean storesUpperCaseIdentifiers()
public abstract boolean storesUpperCaseQuotedIdentifiers()
public abstract boolean supportsAlterTableWithAddColumn()
public abstract boolean supportsAlterTableWithDropColumn()
public abstract boolean supportsANSI92EntryLevelSQL()
public abstract boolean supportsANSI92FullSQL()
public abstract boolean supportsANSI92IntermediateSQL()
public abstract boolean supportsBatchUpdates()
public abstract boolean supportsCatalogsInDataManipulation()
public abstract boolean supportsCatalogsInIndexDefinitions()
public abstract boolean supportsCatalogsInPrivilegeDefinitions()
public abstract boolean supportsCatalogsInProcedureCalls()
public abstract boolean supportsCatalogsInTableDefinitions()
public abstract boolean supportsColumnAliasing()
public abstract boolean supportsConvert( int fromType, int toType )
public abstract boolean supportsConvert()
public abstract boolean supportsCoreSQLGrammar()
public abstract boolean supportsCorrelatedSubqueries()
public abstract boolean supportsDataDefinitionAndDataManipulationTransactions()
public abstract boolean supportsDataManipulationTransactionsOnly()
public abstract boolean supportsDifferentTableCorrelationNames()
public abstract boolean supportsExpressionsInOrderBy()
public abstract boolean supportsExtendedSQLGrammar()
public abstract boolean supportsFullOuterJoins()
public abstract boolean supportsGetGeneratedKeys()
public abstract boolean supportsGroupBy()
public abstract boolean supportsGroupByBeyondSelect()
public abstract boolean supportsGroupByUnrelated()
public abstract boolean supportsIntegrityEnhancementFacility()
public abstract boolean supportsLikeEscapeClause()
public abstract boolean supportsLimitedOuterJoins()
public abstract boolean supportsMinimumSQLGrammar()
public abstract boolean supportsMixedCaseIdentifiers()
public abstract boolean supportsMixedCaseQuotedIdentifiers()
public abstract boolean supportsMultipleOpenResults()
public abstract boolean supportsMultipleResultSets()
public abstract boolean supportsMultipleTransactions()
public abstract boolean supportsNamedParameters()
public abstract boolean supportsNonNullableColumns()
public abstract boolean supportsOpenCursorsAcrossCommit()
public abstract boolean supportsOpenCursorsAcrossRollback()
public abstract boolean supportsOpenStatementsAcrossCommit()
public abstract boolean supportsOpenStatementsAcrossRollback()
public abstract boolean supportsOrderByUnrelated()
public abstract boolean supportsOuterJoins()
public abstract boolean supportsPositionedDelete()
public abstract boolean supportsPositionedUpdate()
public default boolean supportsRefCursors()
public abstract boolean supportsResultSetConcurrency( int type, int concurrency )
public abstract boolean supportsResultSetHoldability( int holdability )
public abstract boolean supportsResultSetType( int type )
public abstract boolean supportsSavepoints()
public abstract boolean supportsSchemasInDataManipulation()
public abstract boolean supportsSchemasInIndexDefinitions()
public abstract boolean supportsSchemasInPrivilegeDefinitions()
public abstract boolean supportsSchemasInProcedureCalls()
public abstract boolean supportsSchemasInTableDefinitions()
public abstract boolean supportsSelectForUpdate()
public default boolean supportsSharding()
public abstract boolean supportsStatementPooling()
public abstract boolean supportsStoredFunctionsUsingCallSyntax()
public abstract boolean supportsStoredProcedures()
public abstract boolean supportsSubqueriesInComparisons()
public abstract boolean supportsSubqueriesInExists()
public abstract boolean supportsSubqueriesInIns()
public abstract boolean supportsSubqueriesInQuantifieds()
public abstract boolean supportsTableCorrelationNames()
public abstract boolean supportsTransactionIsolationLevel( int level )
public abstract boolean supportsTransactions()
public abstract boolean supportsUnion()
public abstract boolean supportsUnionAll()
public abstract boolean updatesAreDetected( int type )
public abstract boolean usesLocalFilePerTable()
public abstract boolean usesLocalFiles()