Help Center> Data Warehouse Service> Troubleshooting> Database Use> An Error Is Reported During SQL Statement Execution, Indicating that the Schema Exists
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.
1 | 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
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.