sdetable unregister

2627
5
Jump to solution
10-30-2013 01:10 AM
MicheleDe_Santis
New Contributor
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
0 Kudos
1 Solution

Accepted Solutions
VinceAngelo
Esri Esteemed Contributor
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

View solution in original post

0 Kudos
5 Replies
VinceAngelo
Esri Esteemed Contributor
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
0 Kudos
marlinAleman
New Contributor

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

thomasmontgomery1
New Contributor

lol

0 Kudos
Asrujit_SenGupta
MVP Regular Contributor

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
New Contributor

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.

0 Kudos