topic Re: Unregistering a Spatial View in Data Management Questions

Unregistering a Spatial View

PhilippeChessel1 — Fri, 09 Mar 2018 13:30:40 GMT

Hi ,

With ArcSDE Geodatabase (10.1) there was a command line to unregister a spatial table or view.

At 10.6 , there is not anymore the sde command line. So I am using the Geodatabase Register tool to Register an SQL Spatial View in the Geodatabase . That is working fine.

I can not see a Unregister tool in the ArcCatalog toolbox and python ?

Is it not needed anymore to Unregister s Spatail View when the SQL View is drop outside of ArcCatalog ?

Philippe Chessel

Re: Unregistering a Spatial View

George_Thompson — Fri, 09 Mar 2018 13:59:57 GMT

You may need to delete the view in ArcCatalog in order to remove if from the Geodatabase. If you do it on the RDBMS side, it may leave an orphaned entry.

You are correct that there is no longer an "unregister" tool.

The data in registered or unregistered views cannot be edited from ArcGIS. Once you register a view with the geodatabase, you should not edit its definition or the data it contains outside ArcGIS.

Geodatabase‌

Re: Unregistering a Spatial View

PhilippeChessel1 — Fri, 09 Mar 2018 15:55:35 GMT

We are currently migrating an ESRI Enterprise Environment from Oracle to SQL Server (then Azure).

And I script a lot of the migration using ArcPy, to be able to re-run it as needed.

So it is a lot more convenient and efficient to create all the Spatial Views in the SQL Server/Studio environment and then use ArcPy to Register, Grant ....

So I just wanted to add the unregister Feature Class (View) before recreating the Views to be sure that geodatabase is clean.

As don't know what the Register Views add in the geodatabase dictionary (?) ,

I can then only assume that when you ALTER a View in SQL Server, the related Spatial View does not need to be Registered again

Re: Unregistering a Spatial View

VinceAngelo — Fri, 09 Mar 2018 16:43:14 GMT

ArcGIS has never had an "unregister" option for geodatabase objects. There was sdelayer -o delete in the ArcSDE command-line tools, but that has ALWAYS corrupted geodatabase metadata, and inappropriate use like this was one of the reasons the entire command-line toolset was deprecated.

The only supported way to "unregister" a view is to delete it from Desktop/Pro/arcpy, after which you can recreate with SQL and re-register (if you must).

ALTERing a view could corrupt geodatabase metadata; once registered, you really should not alter a view or table via SQL.

- V

Re: Unregistering a Spatial View

PhilippeChessel1 — Mon, 12 Mar 2018 08:05:51 GMT

Thanks for these details Angelo.

So will adopt below workflow from now:

Initially:

1. Create the View is SQL rdbms

2. Register the View with ArcGIS

Then when altering is needed:

1. Delete the view with ArcGIS

2. Recreate the View in SQL rdbms

3. Register the View with ArcGIS

Re: Unregistering a Spatial View

AndresCastillo — Wed, 10 Feb 2021 03:54:39 GMT

Esri doc supporting @VinceAngelo reply:

https://desktop.arcgis.com/en/arcmap/latest/manage-data/geodatabases/registering-a-table-with-the-geodatabase.htm