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.

• 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. - To start: The drop operation yet to be initiated. - In progress: The object is currently being dropped. - Completed: The drop operation has been completed. - 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.

   

   • Select part of cell content and press Ctrl+C or click 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.