topic Re: Why Can't a Layer be De-Registered with the SDE in Data Management Questions

Why Can't a Layer be De-Registered with the SDE

MatthewRyan2 — Thu, 02 Jan 2025 00:35:12 GMT

I've not found a way in the new ESRI world to unregister a SDE layer. The only option catalogue gives me is to delete it. Does anyone know how to just unregister the layer???

We can't do this for SQL Server or Oracle.

At time of Post - ArcGIS for Desktop 10.3.1

EDIT: Currently ArcGIS for Desktop 10.8.1 (Still have this problem)

EDIT2: ArcGIS Pro 3.2 still doesn't have this feature - idea to fix the issue found at Unregister SDE Table from Catalog (without deletin... - Esri Community

The problem is that the only other option is to delete the table which means all the triggers, data, indexes and EVERYTHING to do with that table is lost. That is a very destructive functionality for an enterprise application.

If this can't be done then why?

Re: Why Can't a Layer be De-Registered with the SDE

AdrianWelsh — Thu, 12 May 2016 05:25:00 GMT

Hi Matthew,

I am not really sure but found a few resources that may be helpful. Take a look at these sites:

Re: Why Can't a Layer be De-Registered with the SDE

UmakantJoglekar2 — Thu, 12 May 2016 05:35:39 GMT

You may try running commands mentioned in technical article #18341 using 10.2.1 command line against 10.3 geodatabase. This SHOULD work per below article:

44300 - Can ArcSDE command line tools be used against 10.3 and newer geodatabases?

Re: Why Can't a Layer be De-Registered with the SDE

MatthewRyan2 — Fri, 13 May 2016 03:01:04 GMT

Umakant Joglekar this is correct. We are currently using that approach. The problem is that ESRI have made it clear that command line tools from those versions of ArcGIS will NOT be supported going forward. If that's the intention then we need the ability to deregister a table without being destructive.

There is this big risk that one day we will have to jump into the database and manually edit the SDE. Sure, that is fun but not ideal. Running database scripts in all the environments is not as nice as a button in ArcMap which does a simple task.

Re: Why Can't a Layer be De-Registered with the SDE

juliaharrell2 — Fri, 08 Mar 2019 03:33:49 GMT

>>The problem is that the only other option is to delete the table which means all the triggers, data, indexes

>>and EVERYTHING to do with that table is lost. That is unacceptable functionality for an enterprise application

<sigh> 3 yrs later and they STILL have not provided a replacement for the sde command line "unregister with the geodatabase" function, and this is STILL unacceptable functionality for an enterprise application </sigh>

c'mon ESRI - what's wrong w/ y'all

Re: Why Can't a Layer be De-Registered with the SDE

MatthewRyan2 — Fri, 10 Jan 2020 00:42:40 GMT

Here I am again, back at my Original Post. Any progress here Esri Technical Support‌

Re: Why Can't a Layer be De-Registered with the SDE

Asrujit_SenGupta — Wed, 15 Jan 2020 07:59:51 GMT

Probably check ArcGIS Ideas‌ for any similar Ideas already suggested. If not, submit a new one and let other members, who feel this is needed and useful, vote on that idea.

Re: Why Can't a Layer be De-Registered with the SDE

MatthewRyan2 — Tue, 22 Jun 2021 08:16:35 GMT

There is now an idea posted - https://community.esri.com/ideas/17869

Re: Why Can't a Layer be De-Registered with the SDE

RémyGourrat — Tue, 21 Jan 2020 07:58:16 GMT

I voted Yes ! No destructive operation to go out from sde.

Re: Why Can't a Layer be De-Registered with the SDE

ClaudioRuschel — Fri, 15 Jan 2021 14:33:08 GMT

It is more than an idea, it is an obvious requisite, like a regular CRUD operation. If you register a table "by accident"; you must have the resource to undo the operation.