Dropping a Batch of Objects

The batch drop operation allows you select multiple objects to drop. You can also perform batch drop operation on searched objects.

Note

  • Batch drop is allowed only within a database.

  • Batch drop of system objects will result in error, since system objects cannot be dropped.

Follow the steps below to drop objects in a batch:

  1. Press Ctrl+left-click (select objects one by one) or Shift+left-click (select objects in a bunch) to select the objects to be dropped.

  2. Right-click and select Drop Objects.

    Drop Objects tab displays with the list of objects to be dropped.

    Column Name

    Description

    Example

    Type

    Displays information on the object type.

    table, views

    Name

    Displays the name of the object.

    public.bs_operation_201804

    Query

    Displays the query that will be executed to drop the object.

    DROP TABLE IF EXISTS public.a123

    Status

    Displays the status of the drop operation.

    • image1 - To start: The drop operation yet to be initiated.

    • image2 - In progress: The object is currently being dropped.

    • image3 - Completed: The drop operation has been completed.

    • image4 - Error: The object has not been dropped due to an error.

    • To start

    • In progress

    • Completed

    • Error

    Error Message

    Displays the failure reason of the drop operation.

    Table "abc" does not exist. Skip it.

  3. Select the required drop option:

    Option

    Description

    Cascade

    Cascade drop operation drops their dependent objects and attributes. The dependent objects that are dropped will be removed from the Object Browser only after refresh operation is performed.

    Atomic

    Atomic drop operation drops all objects in case of success or drops none in case of a failure.

    No selection

    Un-selection of Atomic or Cascade does not drop dependent objects.

  4. Click Start.

    Runs - Displays the number of objects that are dropped from the total list of objects.

    Errors - Displays the number of object that was not dropped due to errors.

  5. Click Stop or close the Drop Objects dialog to stop the drop operation.

    Refer to Execute SQL Queries section for information on copy, advanced copy, show/hide search bar, sort, and column reorder options.

    Note

    • Select part of cell content and press Ctrl+C or click image5 to copy selected text from a cell.

    • When you select multiple objects in object browser to drop, a batch drop window is opened and its menu icons are enabled in the menu bar. If you disconnect the database, the icons will remain disabled and will not be enabled even after reconnecting. You need to reselect the objects to drop and the selected objects will be available in the new terminal window.