cannot drop table test because other objects depend on it Is Displayed When a Table Is Deleted
Symptom
Error cannot drop table test because other objects depend on it is displayed when a table is deleted, as shown in the following figure.
Possible Causes
After table t1 is created, a sequence is implicitly created. When table t2 is created, the sequence is referenced. When table t1 is deleted, the sequence will be deleted but other objects depend on the sequence. As a result, the error is reported.
Handling Procedure
If t2 does not need to be retained, run DROP CASCADE to delete t1. If t2 and the sequence need to be retained, delete t1 by referring to the following figure.
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