Help Center > > Developer Guide> Query Performance Optimization> Troubleshooting Errors Using SQL Statements> DROP TABLE Fails to Be Executed

DROP TABLE Fails to Be Executed

Updated at:Mar 13, 2020 GMT+08:00

Problem

DROP TABLE fails to be executed in the following scenarios:

  • A user runs the \dt+ command using gsql and finds that the table_name table does not exist. When the user runs the CREATE TABLE table_name command, an error message indicating that the table_name table exists is displayed. When the user runs the DROP TABLE table_name command, an error message indicating that the table_name table does not exist is displayed. In this case, the table_name table cannot be recreated.
  • A user 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 command, an error message indicating that the table_name table does not exist is displayed. In this case, the table_name table cannot be recreated.

Possible Causes

The table_name table exists on some nodes only.

Troubleshooting Method

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.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel