Java in a Nutshell Online Quick Reference for Java 1.1
Availability: JDK 1.1
public abstract interface DatabaseMetaData { // Constants public static final int bestRowNotPseudo; public static final int bestRowPseudo; public static final int bestRowSession; public static final int bestRowTemporary; public static final int bestRowTransaction; public static final int bestRowUnknown; public static final int columnNoNulls; public static final int columnNullable; public static final int columnNullableUnknown; public static final int importedKeyCascade; public static final int importedKeyInitiallyDeferred; public static final int importedKeyInitiallyImmediate; public static final int importedKeyNoAction; public static final int importedKeyNotDeferrable; public static final int importedKeyRestrict; public static final int importedKeySetDefault; public static final int importedKeySetNull; public static final int procedureColumnIn; public static final int procedureColumnInOut; public static final int procedureColumnOut; public static final int procedureColumnResult; public static final int procedureColumnReturn; public static final int procedureColumnUnknown; public static final int procedureNoNulls; public static final int procedureNoResult; public static final int procedureNullable; public static final int procedureNullableUnknown; public static final int procedureResultUnknown; public static final int procedureReturnsResult; public static final short tableIndexClustered; public static final short tableIndexHashed; public static final short tableIndexOther; public static final short tableIndexStatistic; public static final int typeNoNulls; public static final int typeNullable; public static final int typeNullableUnknown; public static final int typePredBasic; public static final int typePredChar; public static final int typePredNone; public static final int typeSearchable; public static final int versionColumnNotPseudo; public static final int versionColumnPseudo; public static final 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; }