Help Center/ GaussDB(DWS)/ Troubleshooting/ Database Use/ An Error Is Reported During SQL Statement Execution, Indicating that the Schema Exists

Updated on 2024-03-08 GMT+08:00

View PDF

An Error Is Reported During SQL Statement Execution, Indicating that the Schema Exists

Symptom

When the CREATE SCHEMA statement is executed, an error message is displayed, indicating that the schema exists.

    
         ERROR: schema "schema" already exists

Possible Causes

In SQL statements, column names are case-sensitive, and are in lowercase by default.

Handling Procedure

In case-sensitive scenarios, you need to add double quotation marks to a column name. Run the SQL statement again, as shown in the following figure. The creation is successful.

Parent topic: Database Use

Previous topic: When a User Specifies Only an Index Name to Modify the Index, A Message Indicating That the Index Does Not Exist Is Displayed

Next topic: Failed to Delete a Database and an Error Is Reported Indicating that a Session Is Connected to the Database

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel