Interface java.sql.DatabaseMetaData (1.1)
public abstract interface DatabaseMetaData {
// Constants
public final static int bestRowNotPseudo;
public final static int bestRowPseudo;
public final static int bestRowSession;
public final static int bestRowTemporary;
public final static int bestRowTransaction;
public final static int bestRowUnknown;
public final static int columnNoNulls;
public final static int columnNullable;
public final static int columnNullableUnknown;
public final static int importedKeyCascade;
public final static int importedKeyInitiallyDeferred;
public final static int importedKeyInitiallyImmediate;
public final static int importedKeyNoAction;
public final static int importedKeyNotDeferrable;
public final static int importedKeyRestrict;
public final static int importedKeySetDefault;
public final static int importedKeySetNull;
public final static int procedureColumnIn;
public final static int procedureColumnInOut;
public final static int procedureColumnOut;
public final static int procedureColumnResult;
public final static int procedureColumnReturn;
public final static int procedureColumnUnknown;
public final static int procedureNoNulls;
public final static int procedureNoResult;
public final static int procedureNullable;
public final static int procedureNullableUnknown;
public final static int procedureResultUnknown;
public final static int procedureReturnsResult;
public final static short tableIndexClustered;
public final static short tableIndexHashed;
public final static short tableIndexOther;
public final static short tableIndexStatistic;
public final static int typeNoNulls;
public final static int typeNullable;
public final static int typeNullableUnknown;
public final static int typePredBasic;
public final static int typePredChar;
public final static int typePredNone;
public final static int typeSearchable;
public final static int versionColumnNotPseudo;
public final static int versionColumnPseudo;
public final static int versionColumnUnknown;
// Public Instance Methods
public abstract boolean allProceduresAreCallable( ) throws SQLException;
public abstract boolean allTablesAreSelectable( ) throws SQLException;
public abstract boolean dataDefinitionCausesTransactionCommit( ) throws SQLException;
public abstract boolean dataDefinitionIgnoredInTransactions( ) throws SQLException;
public abstract boolean doesMaxRowSizeIncludeBlobs( ) throws SQLException;
public abstract ResultSet getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable) throws SQLException;
public abstract String getCatalogSeparator( ) throws SQLException;
public abstract String getCatalogTerm( ) throws SQLException;
public abstract ResultSet getCatalogs( ) throws SQLException;
public abstract ResultSet getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern) throws SQLException;
public abstract ResultSet getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) throws SQLException;
public abstract ResultSet getCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable) throws SQLException;
public abstract String getDatabaseProductName( ) throws SQLException;
public abstract String getDatabaseProductVersion( ) throws SQLException;
public abstract int getDefaultTransactionIsolation( ) throws SQLException;
public abstract int getDriverMajorVersion( );
public abstract int getDriverMinorVersion( );
public abstract String getDriverName( ) throws SQLException;
public abstract String getDriverVersion( ) throws SQLException;
public abstract ResultSet getExportedKeys(String catalog, String schema, String table) throws SQLException;
public abstract String getExtraNameCharacters( ) throws SQLException;
public abstract String getIdentifierQuoteString( ) throws SQLException;
public abstract ResultSet getImportedKeys(String catalog, String schema, String table) throws SQLException;
public abstract ResultSet getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate) throws SQLException;
public abstract int getMaxBinaryLiteralLength( ) throws SQLException;
public abstract int getMaxCatalogNameLength( ) throws SQLException;
public abstract int getMaxCharLiteralLength( ) throws SQLException;
public abstract int getMaxColumnNameLength( ) throws SQLException;
public abstract int getMaxColumnsInGroupBy( ) throws SQLException;
public abstract int getMaxColumnsInIndex( ) throws SQLException;
public abstract int getMaxColumnsInOrderBy( ) throws SQLException;
public abstract int getMaxColumnsInSelect( ) throws SQLException;
public abstract int getMaxColumnsInTable( ) throws SQLException;
public abstract int getMaxConnections( ) throws SQLException;
public abstract int getMaxCursorNameLength( ) throws SQLException;
public abstract int getMaxIndexLength( ) throws SQLException;
public abstract int getMaxProcedureNameLength( ) throws SQLException;
public abstract int getMaxRowSize( ) throws SQLException;
public abstract int getMaxSchemaNameLength( ) throws SQLException;
public abstract int getMaxStatementLength( ) throws SQLException;
public abstract int getMaxStatements( ) throws SQLException;
public abstract int getMaxTableNameLength( ) throws SQLException;
public abstract int getMaxTablesInSelect( ) throws SQLException;
public abstract int getMaxUserNameLength( ) throws SQLException;
public abstract String getNumericFunctions( ) throws SQLException;
public abstract ResultSet getPrimaryKeys(String catalog, String schema, String table) throws SQLException;
public abstract ResultSet getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) throws SQLException;
public abstract String getProcedureTerm( ) throws SQLException;
public abstract ResultSet getProcedures(String catalog, String schemaPattern, String procedureNamePattern) throws SQLException;
public abstract String getSQLKeywords( ) throws SQLException;
public abstract String getSchemaTerm( ) throws SQLException;
public abstract ResultSet getSchemas( ) throws SQLException;
public abstract String getSearchStringEscape( ) throws SQLException;
public abstract String getStringFunctions( ) throws SQLException;
public abstract String getSystemFunctions( ) throws SQLException;
public abstract ResultSet getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern) throws SQLException;
public abstract ResultSet getTableTypes( ) throws SQLException;
public abstract ResultSet getTables(String catalog, String schemaPattern, String tableNamePattern, String[ ] types) throws SQLException;
public abstract String getTimeDateFunctions( ) throws SQLException;
public abstract ResultSet getTypeInfo( ) throws SQLException;
public abstract String getURL( ) throws SQLException;
public abstract String getUserName( ) throws SQLException;
public abstract ResultSet getVersionColumns(String catalog, String schema, String table) throws SQLException;
public abstract boolean isCatalogAtStart( ) throws SQLException;
public abstract boolean isReadOnly( ) throws SQLException;
public abstract boolean nullPlusNonNullIsNull( ) throws SQLException;
public abstract boolean nullsAreSortedAtEnd( ) throws SQLException;
public abstract boolean nullsAreSortedAtStart( ) throws SQLException;
public abstract boolean nullsAreSortedHigh( ) throws SQLException;
public abstract boolean nullsAreSortedLow( ) throws SQLException;
public abstract boolean storesLowerCaseIdentifiers( ) throws SQLException;
public abstract boolean storesLowerCaseQuotedIdentifiers( ) throws SQLException;
public abstract boolean storesMixedCaseIdentifiers( ) throws SQLException;
public abstract boolean storesMixedCaseQuotedIdentifiers( ) throws SQLException;
public abstract boolean storesUpperCaseIdentifiers( ) throws SQLException;
public abstract boolean storesUpperCaseQuotedIdentifiers( ) throws SQLException;
public abstract boolean supportsANSI92EntryLevelSQL( ) throws SQLException;
public abstract boolean supportsANSI92FullSQL( ) throws SQLException;
public abstract boolean supportsANSI92IntermediateSQL( ) throws SQLException;
public abstract boolean supportsAlterTableWithAddColumn( ) throws SQLException;
public abstract boolean supportsAlterTableWithDropColumn( ) throws SQLException;
public abstract boolean supportsCatalogsInDataManipulation( ) throws SQLException;
public abstract boolean supportsCatalogsInIndexDefinitions( ) throws SQLException;
public abstract boolean supportsCatalogsInPrivilegeDefinitions( ) throws SQLException;
public abstract boolean supportsCatalogsInProcedureCalls( ) throws SQLException;
public abstract boolean supportsCatalogsInTableDefinitions( ) throws SQLException;
public abstract boolean supportsColumnAliasing( ) throws SQLException;
public abstract boolean supportsConvert( ) throws SQLException;
public abstract boolean supportsConvert(int fromType, int toType) throws SQLException;
public abstract boolean supportsCoreSQLGrammar( ) throws SQLException;
public abstract boolean supportsCorrelatedSubqueries( ) throws SQLException;
public abstract boolean supportsDataDefinitionAndDataManipulationTransactions( ) throws SQLException;
public abstract boolean supportsDataManipulationTransactionsOnly( ) throws SQLException;
public abstract boolean supportsDifferentTableCorrelationNames( ) throws SQLException;
public abstract boolean supportsExpressionsInOrderBy( ) throws SQLException;
public abstract boolean supportsExtendedSQLGrammar( ) throws SQLException;
public abstract boolean supportsFullOuterJoins( ) throws SQLException;
public abstract boolean supportsGroupBy( ) throws SQLException;
public abstract boolean supportsGroupByBeyondSelect( ) throws SQLException;
public abstract boolean supportsGroupByUnrelated( ) throws SQLException;
public abstract boolean supportsIntegrityEnhancementFacility( ) throws SQLException;
public abstract boolean supportsLikeEscapeClause( ) throws SQLException;
public abstract boolean supportsLimitedOuterJoins( ) throws SQLException;
public abstract boolean supportsMinimumSQLGrammar( ) throws SQLException;
public abstract boolean supportsMixedCaseIdentifiers( ) throws SQLException;
public abstract boolean supportsMixedCaseQuotedIdentifiers( ) throws SQLException;
public abstract boolean supportsMultipleResultSets( ) throws SQLException;
public abstract boolean supportsMultipleTransactions( ) throws SQLException;
public abstract boolean supportsNonNullableColumns( ) throws SQLException;
public abstract boolean supportsOpenCursorsAcrossCommit( ) throws SQLException;
public abstract boolean supportsOpenCursorsAcrossRollback( ) throws SQLException;
public abstract boolean supportsOpenStatementsAcrossCommit( ) throws SQLException;
public abstract boolean supportsOpenStatementsAcrossRollback( ) throws SQLException;
public abstract boolean supportsOrderByUnrelated( ) throws SQLException;
public abstract boolean supportsOuterJoins( ) throws SQLException;
public abstract boolean supportsPositionedDelete( ) throws SQLException;
public abstract boolean supportsPositionedUpdate( ) throws SQLException;
public abstract boolean supportsSchemasInDataManipulation( ) throws SQLException;
public abstract boolean supportsSchemasInIndexDefinitions( ) throws SQLException;
public abstract boolean supportsSchemasInPrivilegeDefinitions( ) throws SQLException;
public abstract boolean supportsSchemasInProcedureCalls( ) throws SQLException;
public abstract boolean supportsSchemasInTableDefinitions( ) throws SQLException;
public abstract boolean supportsSelectForUpdate( ) throws SQLException;
public abstract boolean supportsStoredProcedures( ) throws SQLException;
public abstract boolean supportsSubqueriesInComparisons( ) throws SQLException;
public abstract boolean supportsSubqueriesInExists( ) throws SQLException;
public abstract boolean supportsSubqueriesInIns( ) throws SQLException;
public abstract boolean supportsSubqueriesInQuantifieds( ) throws SQLException;
public abstract boolean supportsTableCorrelationNames( ) throws SQLException;
public abstract boolean supportsTransactionIsolationLevel(int level) throws SQLException;
public abstract boolean supportsTransactions( ) throws SQLException;
public abstract boolean supportsUnion( ) throws SQLException;
public abstract boolean supportsUnionAll( ) throws SQLException;
public abstract boolean usesLocalFilePerTable( ) throws SQLException;
public abstract boolean usesLocalFiles( ) throws SQLException;
}