How To: Remove orphaned objects (feature classes) from a geodatabase
In the event of data or users being removed from a back-end database, geodatabase objects are sometimes orphaned. The most likely causes for this are:
- The objects were unintentionally dropped by a user with a SQL command.
- During database migration, the geodatabase objects were lost.
The instructions provided describe how to remove an orphaned object from a geodatabase. Before proceeding with the following workflow, ensure a recent verified and tested backup has been completed.
- In the back-end database, use SQL to create a table with the same name as the orphaned object.
CREATE TABLE <orphaned_table_name>
- Use ArcCatalog to delete <orphaned_table_name>.
- To add the feature class back in to the geodatabase, create the feature class in ArcCatalog with the same name.
Article ID: 000011812
Software: ArcSDE 10, 10.1, 10.2, 9.3.1; ArcGIS Desktop 10.2, 10.2.1, 10.2.2, 10.3, 10.3.1, 10.4, 10.4.1, 10.5, 10.5.1; ArcGIS Server / Enterprise 10.2, 10.2.1, 10.2.2, 10.3, 10.3.1, 10.4, 10.4.1, 10.5, 10.5.1