Can't delete SDE feature class (SQL)

[MKnapp]

Hi there -

We've got an SDE feature class (that we have full permissions to) that has become corrupted...meaning that it can no longer be truncated, and we cannot delete it as well. 

We've tried deleting via tools in ArcCatalog, and Pro.

We've looked for locks in the SQL Activity Monitor, but there are none. 

Is there a non-desktop process for deleting a feature class outside of Desktop/Pro. 

Have done some looking though Community posts and the consensus seems to be "call tech support".

Thanks.

[ABishop]

Hello,

This may help?

https://community.esri.com/t5/data-management-questions/can-t-delete-feature-class-in-sde/m-p/96463#... 

[MKnapp]

Thanks Amanda.... this isn't quite our issue... we think the feature class has some orphaned locks on it. We're currently looking at ways that we can stop all connections to the database, then identify and clear out the orphaned locks in SQL. 

-Mike

[Reinaldo_Cartagena]

Hi, you can use a python script. There is a guide in the following link:

https://desktop.arcgis.com/es/arcmap/10.6/tools/data-management-toolbox/delete-features.htm 

Reinaldo.