Google Apps Script API
    Preparing search index...

    Interface JdbcDatabaseMetaData

    A JDBC database metadata object. For documentation of this class, see java.sql.DatabaseMetaData.

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

    Methods

    allProceduresAreCallable allTablesAreSelectable autoCommitFailureClosesAllResultSets dataDefinitionCausesTransactionCommit dataDefinitionIgnoredInTransactions deletesAreDetected doesMaxRowSizeIncludeBlobs getAttributes getBestRowIdentifier getCatalogs getCatalogSeparator getCatalogTerm getClientInfoProperties getColumnPrivileges getColumns getConnection getCrossReference getDatabaseMajorVersion getDatabaseMinorVersion getDatabaseProductName getDatabaseProductVersion getDefaultTransactionIsolation getDriverMajorVersion getDriverMinorVersion getDriverName getDriverVersion getExportedKeys getExtraNameCharacters getFunctionColumns getFunctions getIdentifierQuoteString getImportedKeys getIndexInfo getJDBCMajorVersion getJDBCMinorVersion getMaxBinaryLiteralLength getMaxCatalogNameLength getMaxCharLiteralLength getMaxColumnNameLength getMaxColumnsInGroupBy getMaxColumnsInIndex getMaxColumnsInOrderBy getMaxColumnsInSelect getMaxColumnsInTable getMaxConnections getMaxCursorNameLength getMaxIndexLength getMaxProcedureNameLength getMaxRowSize getMaxSchemaNameLength getMaxStatementLength getMaxStatements getMaxTableNameLength getMaxTablesInSelect getMaxUserNameLength getNumericFunctions getPrimaryKeys getProcedureColumns getProcedures getProcedureTerm getResultSetHoldability getRowIdLifetime getSchemas getSchemaTerm getSearchStringEscape getSQLKeywords getSQLStateType getStringFunctions getSuperTables getSuperTypes getSystemFunctions getTablePrivileges getTables getTableTypes getTimeDateFunctions getTypeInfo getUDTs getURL getUserName getVersionColumns insertsAreDetected isCatalogAtStart isReadOnly locatorsUpdateCopy nullPlusNonNullIsNull nullsAreSortedAtEnd nullsAreSortedAtStart nullsAreSortedHigh nullsAreSortedLow othersDeletesAreVisible othersInsertsAreVisible othersUpdatesAreVisible ownDeletesAreVisible ownInsertsAreVisible ownUpdatesAreVisible storesLowerCaseIdentifiers storesLowerCaseQuotedIdentifiers storesMixedCaseIdentifiers storesMixedCaseQuotedIdentifiers storesUpperCaseIdentifiers storesUpperCaseQuotedIdentifiers supportsAlterTableWithAddColumn supportsAlterTableWithDropColumn supportsANSI92EntryLevelSQL supportsANSI92FullSQL supportsANSI92IntermediateSQL supportsBatchUpdates supportsCatalogsInDataManipulation supportsCatalogsInIndexDefinitions supportsCatalogsInPrivilegeDefinitions supportsCatalogsInProcedureCalls supportsCatalogsInTableDefinitions supportsColumnAliasing supportsConvert supportsCoreSQLGrammar supportsCorrelatedSubqueries supportsDataDefinitionAndDataManipulationTransactions supportsDataManipulationTransactionsOnly supportsDifferentTableCorrelationNames supportsExpressionsInOrderBy supportsExtendedSQLGrammar supportsFullOuterJoins supportsGetGeneratedKeys supportsGroupBy supportsGroupByBeyondSelect supportsGroupByUnrelated supportsIntegrityEnhancementFacility supportsLikeEscapeClause supportsLimitedOuterJoins supportsMinimumSQLGrammar supportsMixedCaseIdentifiers supportsMixedCaseQuotedIdentifiers supportsMultipleOpenResults supportsMultipleResultSets supportsMultipleTransactions supportsNamedParameters supportsNonNullableColumns supportsOpenCursorsAcrossCommit supportsOpenCursorsAcrossRollback supportsOpenStatementsAcrossCommit supportsOpenStatementsAcrossRollback supportsOrderByUnrelated supportsOuterJoins supportsPositionedDelete supportsPositionedUpdate supportsResultSetConcurrency supportsResultSetHoldability supportsResultSetType supportsSavepoints supportsSchemasInDataManipulation supportsSchemasInIndexDefinitions supportsSchemasInPrivilegeDefinitions supportsSchemasInProcedureCalls supportsSchemasInTableDefinitions supportsSelectForUpdate supportsStatementPooling supportsStoredFunctionsUsingCallSyntax supportsStoredProcedures supportsSubqueriesInComparisons supportsSubqueriesInExists supportsSubqueriesInIns supportsSubqueriesInQuantifieds supportsTableCorrelationNames supportsTransactionIsolationLevel supportsTransactions supportsUnion supportsUnionAll updatesAreDetected usesLocalFilePerTable usesLocalFiles

    Methods

    Settings
    Member Visibility

    On This Page
    Methods
    allProceduresAreCallable allTablesAreSelectable autoCommitFailureClosesAllResultSets dataDefinitionCausesTransactionCommit dataDefinitionIgnoredInTransactions deletesAreDetected doesMaxRowSizeIncludeBlobs getAttributes getBestRowIdentifier getCatalogs getCatalogSeparator getCatalogTerm getClientInfoProperties getColumnPrivileges getColumns getConnection getCrossReference getDatabaseMajorVersion getDatabaseMinorVersion getDatabaseProductName getDatabaseProductVersion getDefaultTransactionIsolation getDriverMajorVersion getDriverMinorVersion getDriverName getDriverVersion getExportedKeys getExtraNameCharacters getFunctionColumns getFunctions getIdentifierQuoteString getImportedKeys getIndexInfo getJDBCMajorVersion getJDBCMinorVersion getMaxBinaryLiteralLength getMaxCatalogNameLength getMaxCharLiteralLength getMaxColumnNameLength getMaxColumnsInGroupBy getMaxColumnsInIndex getMaxColumnsInOrderBy getMaxColumnsInSelect getMaxColumnsInTable getMaxConnections getMaxCursorNameLength getMaxIndexLength getMaxProcedureNameLength getMaxRowSize getMaxSchemaNameLength getMaxStatementLength getMaxStatements getMaxTableNameLength getMaxTablesInSelect getMaxUserNameLength getNumericFunctions getPrimaryKeys getProcedureColumns getProcedures getProcedureTerm getResultSetHoldability getRowIdLifetime getSchemas getSchemaTerm getSearchStringEscape getSQLKeywords getSQLStateType getStringFunctions getSuperTables getSuperTypes getSystemFunctions getTablePrivileges getTables getTableTypes getTimeDateFunctions getTypeInfo getUDTs getURL getUserName getVersionColumns insertsAreDetected isCatalogAtStart isReadOnly locatorsUpdateCopy nullPlusNonNullIsNull nullsAreSortedAtEnd nullsAreSortedAtStart nullsAreSortedHigh nullsAreSortedLow othersDeletesAreVisible othersInsertsAreVisible othersUpdatesAreVisible ownDeletesAreVisible ownInsertsAreVisible ownUpdatesAreVisible storesLowerCaseIdentifiers storesLowerCaseQuotedIdentifiers storesMixedCaseIdentifiers storesMixedCaseQuotedIdentifiers storesUpperCaseIdentifiers storesUpperCaseQuotedIdentifiers supportsAlterTableWithAddColumn supportsAlterTableWithDropColumn supportsANSI92EntryLevelSQL supportsANSI92FullSQL supportsANSI92IntermediateSQL supportsBatchUpdates supportsCatalogsInDataManipulation supportsCatalogsInIndexDefinitions supportsCatalogsInPrivilegeDefinitions supportsCatalogsInProcedureCalls supportsCatalogsInTableDefinitions supportsColumnAliasing supportsConvert supportsCoreSQLGrammar supportsCorrelatedSubqueries supportsDataDefinitionAndDataManipulationTransactions supportsDataManipulationTransactionsOnly supportsDifferentTableCorrelationNames supportsExpressionsInOrderBy supportsExtendedSQLGrammar supportsFullOuterJoins supportsGetGeneratedKeys supportsGroupBy supportsGroupByBeyondSelect supportsGroupByUnrelated supportsIntegrityEnhancementFacility supportsLikeEscapeClause supportsLimitedOuterJoins supportsMinimumSQLGrammar supportsMixedCaseIdentifiers supportsMixedCaseQuotedIdentifiers supportsMultipleOpenResults supportsMultipleResultSets supportsMultipleTransactions supportsNamedParameters supportsNonNullableColumns supportsOpenCursorsAcrossCommit supportsOpenCursorsAcrossRollback supportsOpenStatementsAcrossCommit supportsOpenStatementsAcrossRollback supportsOrderByUnrelated supportsOuterJoins supportsPositionedDelete supportsPositionedUpdate supportsResultSetConcurrency supportsResultSetHoldability supportsResultSetType supportsSavepoints supportsSchemasInDataManipulation supportsSchemasInIndexDefinitions supportsSchemasInPrivilegeDefinitions supportsSchemasInProcedureCalls supportsSchemasInTableDefinitions supportsSelectForUpdate supportsStatementPooling supportsStoredFunctionsUsingCallSyntax supportsStoredProcedures supportsSubqueriesInComparisons supportsSubqueriesInExists supportsSubqueriesInIns supportsSubqueriesInQuantifieds supportsTableCorrelationNames supportsTransactionIsolationLevel supportsTransactions supportsUnion supportsUnionAll updatesAreDetected usesLocalFilePerTable usesLocalFiles