Help Center/ GaussDB(DWS)/ Troubleshooting/ Database Use/ cannot drop table test because other objects depend on it Is Displayed When a Table Is Deleted
Updated on 2022-12-26 GMT+08:00

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.