How do we clean up entries in SDE.GEOMETRY_COLUMNS and SDE.LAYERS for non-existent tables?

1729
2
06-30-2016 11:15 AM
GeorgiaHarlow
New Contributor

We are running ArcCatalog 10.3.1  and we have two tables that were deleted by a developer that is no longer on the team. Although I don't see the tables in ArcCatalog anymore when I look at the database connection for the schema owner, I see entries in SDE.GEOMETRY_COLUMNS and SDE.LAYERS for these two tables.  Is there a step to clean up these using ArcCatalog or is there a process to follow?  Should I not worry about this data existing for non-existent tables?

Thanks in advance!

0 Kudos
2 Replies
RebeccaStrauch__GISP
MVP Emeritus

tagging Managing DataGeodatabase

Also tagging Thomas Colson  other of the Hacking ArcSDE​  blog....since he usually  has some good ArcSDE tricks.   and this will at least give a bump to your questions.

0 Kudos
AsrujitSengupta
Regular Contributor III

Create a simple Table from the database end with the exact same name and using the same Data Owner.

Open ArcCatalog and then delete that table. It should remove those orphaned entries.