On this page
Help Center/ GaussDB(DWS)/ Troubleshooting/ Database Use/ DROP TABLE Fails to Be Executed

DROP TABLE Fails to Be Executed

Updated on 2022-09-15 GMT+08:00

Symptom

DROP TABLE fails to be executed in the following scenarios:

  • A user runs the SELECT * FROM DBA_TABLES statement (or runs the \dt+ command using gsql) and finds that the table_name table does not exist in the database. When the user runs the CREATE TABLE table_name statement, an error message indicating that the table_name table already exists. When the user runs the DROP TABLE table_name statement, an error message indicating that the table_name table does not exist. In this case, the table_name table cannot be recreated.
  • A user runs the SELECT * FROM DBA_TABLES statement (or runs the \dt+ command using gsql) and finds that the table_name table exists in the database. When the user runs the DROP TABLE table_name statement, an error message indicating that the table_name table does not exist. In this case, the table_name table cannot be recreated.

Cause Analysis

The table_name table exists on some nodes only.

Solution

In the preceding scenarios, if DROP TABLE table_name fails to be executed, run DROP TABLE IF EXISTS table_name to successfully drop table_name.

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback