topic Re: Delete a feature class in Geodatabase Questions

Delete a feature class

YatharthSah — Mon, 02 Mar 2020 06:21:11 GMT

Hi All,

I am unable to delete a feature class from an enterprise Geo-database (SSMS 2012)

The error message being displayed here is :

Failed to rename the object . Underlying DBMS error:

Cannot rename the table because it is published for replication.

-Please be noted that all the services have been stopped prior to deleting the FC.

-This feature participated in Replication previously. However the replication has now been removed and the feature data set has been deleted(even though the feature dataset deleted, I was unable to delete/rename the feature class).

Here is the screenshot:

Any help on this would be highly appreciated.

Regards

Yatharth

Re: Delete a feature class

JoshuaBixby — Mon, 02 Mar 2020 22:44:52 GMT

You are trying to delete (how exactly?) a feature class and a "Rename Failed" is returned?

Re: Delete a feature class

ColinWerle1 — Wed, 04 Mar 2020 03:41:29 GMT

Hi Yatharth,

Did it participate in SQL Server replication or enterprise geodatabase replication? Objects published via SQL Server replication cannot be dropped or renamed. This could be expected behavior and may not have to do with the geodatabase itself. If you want to delete or rename a feature class that participates in SQL Server replication you would first have to remove the object from the publication, or disable replication.

Re: Delete a feature class

YatharthSah — Mon, 28 Jun 2021 15:23:08 GMT

Thanks.

Correct SQL server participated in replication with another database which was the reason we were unable to delete the FC.