sdetable unregister

[MicheleDe_Santis]

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#xunregiste...

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

[VinceAngelo · Accepted solution]

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

[marlinAleman]

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

[thomasmontgomery1]

lol

[Asrujit_SenGupta]

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)

[TomWard]

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.