Skip to main content

  • ​
    clearTables

    public ClearTablesResponse clearTables(ClearTablesRequest request) throws GPUdbException
    Clears (drops) tables in the database cluster. The operation is synchronous meaning that the tables will be cleared before the function returns. The response payload returns the status of the operation for each table requested.
    Parameters:
    request - Request object containing the parameters for the operation.
    Returns:
    Response object containing the results of the operation.
    Throws:
    GPUdbException - if an error occurs during the operation.

  • ​
    clearTables

    public ClearTablesResponse clearTables(List<String> tableNames, Map<String,String> options) throws GPUdbException
    Clears (drops) tables in the database cluster. The operation is synchronous meaning that the tables will be cleared before the function returns. The response payload returns the status of the operation for each table requested.
    Parameters:
    tableNames - Names of the tables to be cleared, in [schema_name.]table_name format, using standard name resolution rules. Must be existing tables. Empty list clears all available tables, though this behavior is be prevented by default via gpudb.conf parameter ‘disable_clear_all’. The default value is an empty List.
    options - Optional parameters.
    • NO_ERROR_IF_NOT_EXISTS: If TRUE and if a table specified in tableNames does not exist no error is returned. If FALSE and if a table specified in tableNames does not exist then an error is returned. Supported values:The default value is FALSE.
    The default value is an empty Map.
    Returns:
    Response object containing the results of the operation.
    Throws:
    GPUdbException - if an error occurs during the operation.