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.
Currently ArcGIS for Desktop 10.3.1
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.
If this can't be done then why?
I am not really sure but found a few resources that may be helpful. Take a look at these sites:
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:
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.
>>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
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.