If a message indicates there is a duplicate database, there might be a database or user that starts with a blank character that is exactly the same as another database or user name. The database or user with the blank at the beginning of the name does not load into the database tree. If this database or user was created in error, use the following procedure to drop it.
To drop a duplicate database or user
✔ In the Query window, type the following where the duplicate name is dbname.
The quotes and blank character are required.
DROP DATABASE “ dbname”
DROP USER “ dbname”
For more information, see “Drop a Database or Database Object” on page 46.