Help Center/ GaussDB(DWS)/ Troubleshooting/ Database Use/ An Error Is Reported During SQL Statement Execution, Indicating that the Schema Exists
Updated on 2023-04-18 GMT+08:00

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.