Batch Dropping Objects
The batch drop operation allows you to drop multiple objects. This operation also applies to searched objects.
- Batch drop is allowed only within a database.
- An error is reported on batch dropping system objects, which cannot be dropped.
Perform the following steps to batch drop objects:
- 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.
- Right-click and select Drop Objects.
The Drop Objects tab displays the list of objects to be dropped.
Column Name
Description
Example
Type
Displays information about the object type.
Table, view
Name
Displays the object name.
public.bs_operation_201804
Query
Displays the query that will be executed to drop objects.
DROP TABLE IF EXISTS public.a123
Status
Displays the status of the drop operation.
- To start: The drop operation has not been started.
- In progress: The object is 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 cause of a drop operation.
The table abc does not exist. Skip it.
- Select the required parameters.
Option
Description
Cascade
The cascade drop operation is performed to drop dependent objects and attributes. The dropped dependent objects will be removed from Object Browser only after the refresh operation is performed.
Atomic
The atomic drop operation is performed to drop all objects. If the operation fails, no objects will be dropped.
No selection
If neither Cascade nor Atomic is selected, no dependent objects are dropped.
- Click Start.
Runs: displays the number of objects that are dropped from the object list
Errors: displays the number of objects that are not dropped due to errors
- Click Stop or close the Drop Objects dialog box to stop the drop operation.
For details about copy, advanced copy, show/hide search bar, sort, and column reorder options, see Executing SQL Queries.
- Select part of a cell and press Ctrl+C or click to copy selected text in the cell.
- When you select multiple objects in Object Browser to drop, a batch drop window is displayed and the object icons are enabled in the menu bar. If you disconnect the database, the icons will remain disabled even after reconnection. In this case, you need to reselect the objects to drop and the selected objects will be displayed in the new batch drop window.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot