Database features

FeatureSupported
allProceduresAreCallabletrue
allTablesAreSelectabletrue
isReadOnlyfalse
nullsAreSortedHighfalse
nullsAreSortedLowtrue
nullsAreSortedAtStartfalse
nullsAreSortedAtEndfalse
usesLocalFilesfalse
usesLocalFilePerTablefalse
supportsMixedCaseIdentifiersfalse
storesUpperCaseIdentifiersfalse
storesLowerCaseIdentifiersfalse
storesMixedCaseIdentifierstrue
supportsMixedCaseQuotedIdentifiersfalse
storesUpperCaseQuotedIdentifiersfalse
storesLowerCaseQuotedIdentifiersfalse
storesMixedCaseQuotedIdentifierstrue
supportsAlterTableWithAddColumnfalse
supportsAlterTableWithDropColumnfalse
nullPlusNonNullIsNullfalse
supportsConvertfalse
supportsTableCorrelationNamesfalse
supportsDifferentTableCorrelationNamesfalse
supportsExpressionsInOrderByfalse
supportsOrderByUnrelatedtrue
supportsGroupByfalse
supportsGroupByUnrelatedfalse
supportsGroupByBeyondSelectfalse
supportsLikeEscapeClausefalse
supportsMultipleResultSetsfalse
supportsMultipleTransactionsfalse
supportsNonNullableColumnstrue
supportsMinimumSQLGrammarfalse
supportsCoreSQLGrammarfalse
supportsExtendedSQLGrammarfalse
supportsANSI92EntryLevelSQLfalse
supportsANSI92IntermediateSQLfalse
supportsANSI92FullSQLfalse
supportsIntegrityEnhancementFacilityfalse
supportsOuterJoinsfalse
supportsFullOuterJoinsfalse
supportsLimitedOuterJoinsfalse
isCatalogAtStarttrue
supportsSchemasInDataManipulationfalse
supportsSchemasInProcedureCallsfalse
supportsSchemasInTableDefinitionsfalse
supportsSchemasInIndexDefinitionsfalse
supportsSchemasInPrivilegeDefinitionsfalse
supportsCatalogsInDataManipulationfalse
supportsCatalogsInProcedureCallsfalse
supportsCatalogsInTableDefinitionsfalse
supportsCatalogsInIndexDefinitionsfalse
supportsCatalogsInPrivilegeDefinitionsfalse
supportsPositionedDeletefalse
supportsPositionedUpdatefalse
supportsSelectForUpdatefalse
supportsStoredProcedurestrue
supportsSubqueriesInComparisonsfalse
supportsSubqueriesInExistsfalse
supportsSubqueriesInInsfalse
supportsSubqueriesInQuantifiedsfalse
supportsCorrelatedSubqueriesfalse
supportsUnionfalse
supportsUnionAllfalse
supportsOpenCursorsAcrossCommitfalse
supportsOpenCursorsAcrossRollbackfalse
supportsOpenStatementsAcrossCommittrue
supportsOpenStatementsAcrossRollbackfalse
doesMaxRowSizeIncludeBlobstrue
supportsTransactionsfalse
supportsTransactionIsolationLevelfalse
supportsDataDefinitionAndDataManipulationTransactionsfalse
supportsDataManipulationTransactionsOnlytrue
dataDefinitionCausesTransactionCommitfalse
dataDefinitionIgnoredInTransactionstrue
getMaxBinaryLiteralLength0
getMaxCharLiteralLength64000
getMaxColumnNameLength60
getMaxColumnsInGroupBy0
getMaxColumnsInIndex0
getMaxColumnsInOrderBy256000000
getMaxColumnsInSelect256000000
getMaxColumnsInTable256000000
getMaxConnections25
getMaxCursorNameLength0
getMaxIndexLength0
getMaxSchemaNameLength0
getMaxProcedureNameLength250
getMaxCatalogNameLength1024
getMaxRowSize2147483647
getMaxStatementLength2147483647
getMaxStatements2147483647
getMaxTableNameLength31
getMaxTablesInSelect1
getMaxUserNameLength64000
getDefaultTransactionIsolation0
getDatabaseProductNameFileMaker Pro Web Companion
getDatabaseProductVersion5.5v3 10/10/2001
getURLjdbc:fmpro:http://141.14.237.74:8050
getUserNamerogo
getDriverNameFileMaker Pro Driver
getIdentifierQuoteString"
getDriverVersion1.0v3 6/19/2001
getDriverMajorVersion1
getDriverMinorVersion0
getSQLKeywordsLAYOUT
getNumericFunctions
getStringFunctions
getSystemFunctions
getTimeDateFunctions
getSearchStringEscape
getExtraNameCharacters .!#$';?@[\]`{|}~
getSchemaTerm
getProcedureTermScript
getCatalogTermDomain
getCatalogSeparator/