idea Unregister SDE Table from Catalog (without deleting) in Data Management Ideas

Unregister SDE Table from Catalog (without deleting)

MatthewRyan2 — Tue, 20 Sep 2022 22:07:16 GMT

There is no way to unregister a SDE layer in an enterprise SDE database. The only option catalog gives me is to delete it which is a very destructive operation. This means all the triggers, data, indexes and EVERYTHING to do with that table is lost.

I propose, the ability to de-register a table from Catalog without deleting the table.

Post on the issue with discussion found at - https://community.esri.com/message/902166-re-why-cant-a-layer-be-de-registered-with-the-sde?commentID=902166&et=watches.email.thread#comment-902166

Re: Unregister SDE Table from Catalog (without deleting)

RyanDavis1 — Thu, 06 May 2021 20:08:28 GMT

This idea is sorely needed and should be voted up higher. If I rebuild registered tables or views outside of ArcGIS, the metadata contained inside the SDE tables is no longer accurate and those objects might not even be usable inside of ArcGIS. Basically, I have to be entirely sure that my object is in its final production state before registering.

It's hard for me to fathom that I have to delete the object from within ArcGIS to remove all of the references first. It doesn't seem like it should be huge lift to have a tool that removes all of the references in the SDE tables.

Re: Unregister SDE Table from Catalog (without deleting)

AlisonWieckowicz — Tue, 10 Dec 2024 17:52:17 GMT

I would also consider this to be important to support common enterprise data management tasks.