Not able to delete the schema/Table

Question

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?

DavidKangni · Accepted Answer

@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

Craig_Thonis · Answer

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"

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded