Not able to delete the schema/Table

[SanketPhawde]

Hi,

I have created a table Label="EXT20 Card unlinked event", name="cardUnLinkedEvent" and also one more schema was accidentally created with Label="EXT20 Card Unlinked Event", name="cardUnLinkedEvent". Not sure how it allowed to create with same name. when i tried to rename one of them, two more schema/Table got created. (All four highlighted in blue)

Now, i want to delete all the four schema, but i am getting below error while deleting any of these schema.

Also, while updating the database structure for any of the new schema in that instance I am getting below error.

All the four schemas are custom build, there are no records in schema/Table, there is no linking used in the schema, there is no dependency on this four schema.

How can i delete this four schema?

[Craig_Thonis]

Hi Sanket. I'm not sure about how to delete them if the application is preventing you. It may be something you can do from the DB level. As for how multiple schemas with the same name got created, from the screenshot, it looks like there may be some leading or trailing spaces, and the last entry is using a lowercase "u" in the "unlinked event"

[DavidKangni · Accepted solution]

@SanketPhawde 

Try to delete them one by one instead from the newest to the latest by creation date. and check if you don't have a circular dependency.

You shouldn't change the schemas name (even just character from lowercase to uppercase) as it will create another schema.

Thanks,

David

[Sukrity_Wadhwa]

Hi @SanketPhawde,

Were you able to resolve this query with the help of the provided solutions, or do you still need further assistance? Please let us know. If any of the answers were helpful in moving you closer to a resolution, even partially, we encourage you to mark the one that helped the most as the 'Correct Reply.'

Thank you!