topic Re: sdetable unregister in Data Management Questions

sdetable unregister

MicheleDe_Santis — Wed, 30 Oct 2013 08:10:42 GMT

Hi to all,

I have to unregister a table from sde so I'm using the sdetable -o unregister command. At the follow link

http://help.arcgis.com/en/geodatabase/10.0/admin_cmds/support_files/datamgmt/sdetable.htm#xunregister

I can read that before: "the dependencies must be removed" in example unregister the table from the geodatabase using ArcCatalog.

Can anyone help me to understand how to unregister the table from the geodatabase using ArcCatalog?

Thanks
michele

Re: sdetable unregister

VinceAngelo — Wed, 30 Oct 2013 08:44:55 GMT

The easiest (and safest) way to unregister a table that has been registered with the geodatabase
is to make an export, drop the table (delete through Desktop/ArcObjects/ArcPy) and re-import
the table (alternatively, CREATE TABLE t_new AS SELECT * FROM t", delete, and RENAME).
Any other method will involve unsupported manipulation of the GDB tables.

- V

Re: sdetable unregister

marlinAleman — Thu, 29 Jun 2017 22:59:05 GMT

No idea what you are talking about dude. it makes zero sense.

Re: sdetable unregister

thomasmontgomery1 — Thu, 20 Jul 2017 16:00:17 GMT

lol

Re: sdetable unregister

Asrujit_SenGupta — Thu, 20 Jul 2017 19:35:55 GMT

Honestly, it makes perfect sense if someone cares to read properly and tries to understand the workflow suggested. Instead of trying to use the unregister command from Command line tools (which are anyway deprecated), he is suggesting an alternate and safer way, to avoid any corruption of the Table.

1. make an export,
2. drop the table (delete through Desktop/ArcObjects/ArcPy)
3. re-import the table (alternatively, CREATE TABLE t_new AS SELECT * FROM t", delete, and RENAME).

Any other method will involve unsupported manipulation of the GDB tables.

1. suggesting you to export\create a copy of the concerned table in the same database

2. Delete the existing Table using ArcGIS Desktop\ArcObjects\ArcPy (this removes all dependencies, which was the initial concern)

3. Re-import the copy that you created in Step1 OR Recreate the required table from the copy that you made in Step1 OR Rename the copy that you created in Step1 (whatever suits you)

Re: sdetable unregister

TomWard — Thu, 19 Dec 2019 21:01:38 GMT

The original answer is just lacking a lot of detail and assumes the reader understands SQL. It's NOT a step-by-step. But it is something ESRI should document somewhere. Why isn't there a tool to unregister a table/feature from the geodatabase? Seems reasonable that if there a tool to register then there should be a way to unregister.