| Property Name | Value |
| usesLocalFiles | true |
| usesLocalFilePerTable | false |
| supportsUnionAll | true |
| supportsUnion | true |
| supportsTransactions | true |
| supportsTableCorrelationNames | true |
| supportsSubqueriesInQuantifieds | true |
| supportsSubqueriesInIns | true |
| supportsSubqueriesInExists | true |
| supportsSubqueriesInComparisons | true |
| supportsStoredProcedures | false |
| supportsStatementPooling | false |
| supportsSelectForUpdate | true |
| supportsSchemasInTableDefinitions | true |
| supportsSchemasInProcedureCalls | true |
| supportsSchemasInPrivilegeDefinitions | true |
| supportsSchemasInIndexDefinitions | true |
| supportsSchemasInDataManipulation | true |
| supportsSavepoints | true |
| supportsPositionedUpdate | true |
| supportsPositionedDelete | true |
| supportsOuterJoins | true |
| supportsOrderByUnrelated | true |
| supportsOpenStatementsAcrossRollback | true |
| supportsOpenStatementsAcrossCommit | true |
| supportsOpenCursorsAcrossRollback | false |
| supportsOpenCursorsAcrossCommit | false |
| supportsNonNullableColumns | true |
| supportsNamedParameters | false |
| supportsMultipleTransactions | true |
| supportsMultipleResultSets | false |
| supportsMultipleOpenResults | true |
| supportsMixedCaseQuotedIdentifiers | true |
| supportsMixedCaseIdentifiers | false |
| supportsMinimumSQLGrammar | true |
| supportsLimitedOuterJoins | true |
| supportsLikeEscapeClause | true |
| supportsIntegrityEnhancementFacility | true |
| supportsGroupByUnrelated | true |
| supportsGroupByBeyondSelect | true |
| supportsGroupBy | true |
| supportsGetGeneratedKeys | true |
| supportsFullOuterJoins | false |
| supportsExtendedSQLGrammar | false |
| supportsExpressionsInOrderBy | true |
| supportsDifferentTableCorrelationNames | false |
| supportsDataManipulationTransactionsOnly | true |
| supportsDataDefinitionAndDataManipulationTransactions | false |
| supportsCorrelatedSubqueries | true |
| supportsCoreSQLGrammar | true |
| supportsConvert | true |
| supportsColumnAliasing | true |
| supportsCatalogsInTableDefinitions | false |
| supportsCatalogsInProcedureCalls | false |
| supportsCatalogsInPrivilegeDefinitions | false |
| supportsCatalogsInIndexDefinitions | false |
| supportsCatalogsInDataManipulation | false |
| supportsBatchUpdates | true |
| supportsANSI92IntermediateSQL | false |
| supportsANSI92FullSQL | false |
| supportsANSI92EntryLevelSQL | true |
| supportsAlterTableWithDropColumn | true |
| supportsAlterTableWithAddColumn | true |
| storesUpperCaseQuotedIdentifiers | false |
| storesUpperCaseIdentifiers | true |
| storesMixedCaseQuotedIdentifiers | true |
| storesMixedCaseIdentifiers | false |
| storesLowerCaseQuotedIdentifiers | false |
| storesLowerCaseIdentifiers | false |
| nullsAreSortedLow | true |
| nullsAreSortedHigh | false |
| nullsAreSortedAtStart | false |
| nullsAreSortedAtEnd | false |
| nullPlusNonNullIsNull | true |
| locatorsUpdateCopy | false |
| isReadOnly | false |
| isCatalogAtStart | true |
| getUserName | DBCOPY |
| getURL | jdbc:h2:tcp://localhost:9094/dbcopysrc |
| getSQLStateType | 2 |
| getSearchStringEscape | \ |
| getSchemaTerm | schema |
| getResultSetHoldability | 2 |
| getProcedureTerm | procedure |
| getMaxUserNameLength | 0 |
| getMaxTablesInSelect | 0 |
| getMaxTableNameLength | 0 |
| getMaxStatements | 0 |
| getMaxStatementLength | 0 |
| getMaxSchemaNameLength | 0 |
| getMaxRowSize | 0 |
| getMaxProcedureNameLength | 0 |
| getMaxIndexLength | 0 |
| getMaxCursorNameLength | 0 |
| getMaxConnections | 0 |
| getMaxColumnsInTable | 0 |
| getMaxColumnsInSelect | 0 |
| getMaxColumnsInOrderBy | 0 |
| getMaxColumnsInIndex | 0 |
| getMaxColumnsInGroupBy | 0 |
| getMaxColumnNameLength | 0 |
| getMaxCharLiteralLength | 0 |
| getMaxCatalogNameLength | 0 |
| getMaxBinaryLiteralLength | 0 |
| getJDBCMinorVersion | 0 |
| getJDBCMajorVersion | 3 |
| getIdentifierQuoteString | " |
| getExtraNameCharacters | |
| getDriverVersion | 0.9 (2006-04-08 / Alpha) |
| getDriverName | H2 JDBC Driver |
| getDriverMinorVersion | 9 |
| getDriverMajorVersion | 0 |
| getDefaultTransactionIsolation | TRANSACTION_READ_COMMITTED |
| getDatabaseProductVersion | 0.9 (2006-04-08 / Alpha) |
| getDatabaseProductName | H2 |
| getDatabaseMinorVersion | 9 |
| getDatabaseMajorVersion | 0 |
| getCatalogTerm | catalog |
| getCatalogSeparator | . |
| doesMaxRowSizeIncludeBlobs | false |
| dataDefinitionIgnoredInTransactions | false |
| dataDefinitionCausesTransactionCommit | true |
| allTablesAreSelectable | true |
| allProceduresAreCallable | true |