Not able to delete the schema/Table | Community
Skip to main content
S
SanketPhawde
New Participant
June 4, 2025
Solved

Not able to delete the schema/Table

  • June 4, 2025
  • 3 replies
  • 567 views

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?

Best answer by DavidKangni

@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

 

 

3 replies

Sukrity_Wadhwa
Sukrity_Wadhwa
Employee
June 17, 2025

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!

Sukrity Wadhwa
DavidKangni
DavidKangniAccepted solution
New Participant
June 9, 2025

@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

 

 

David Kangni
    Craig_Thonis
    Craig_Thonis
    Employee
    June 6, 2025

    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"

      Terms & ConditionsAccessibility statement

      Loading footer...