topic Re: sde.layers and sde.table_registry records but no tables in Data Management Questions

sde.layers and sde.table_registry records but no tables

deleted-user-0hg8sVY9GHfr — Wed, 14 Mar 2012 21:16:50 GMT

i'm working with 9.1... how is it that i can find records in the sde.layers and sde.table_registry tables with corresponding records in the sde.geometry_columns table but the attribute and geometry tables don't exist? is this due to an unapproved process for deleting a feature class? just dropping the tables and not de-registering with the sde?

what is the correct process for deleting a feature class? i know that if i can do so using ArcCatalog but haven't tried it. would de-registering with ArcToolbox/General/Delete automatically de-register with the gdb, sde and delete the attribute and shape tables?

thanks in advance.

Re: sde.layers and sde.table_registry records but no tables

VinceAngelo — Wed, 14 Mar 2012 22:48:01 GMT

That's usually a result of bad database hygiene -- Tables registered with ArcSDE should be deleted
with ArcSDE or ArcGIS tools; tables registered with the geodatabase should be deleted only with
ArcGIS.

The best work-around is to create a trivial table via SQL with the same name, then follow correct
removal procedure (you don't generally need to recreate the ArcSDE-managed tables). I don't
recommend hacking the registry tables (very unsupported unless on the phone with Tech Support,
and 9.1 is so retired that 9.2 will be retired soon, so this isn't an option).

- V

Re: sde.layers and sde.table_registry records but no tables

ChrisRobinson — Thu, 24 Oct 2013 19:11:35 GMT

I think I may have a similar problem. I have a table that I can see in ArcCatalog but am unable to delete as it keeps saying there is a missing DBMS table. When I view the geodatabase in SQL Server Management Studio, the only reference to the table I can see is in the sde.sde_layers table. I do not see it listed in the sde.table_registry, sde.column_registry or sde.gdb_objectclasses tables. Also there is no A, D, F, I, or S table that refers to the layer ID from the sde_layers table. Any idea of how to remove? Would removing it through SSMS work since it isn't referenced anywhere else?

ArcSDE 9.3.1
Windows Server 2003
Microsoft SQL Server 2008 R2

Thanks,
Chris

Re: sde.layers and sde.table_registry records but no tables

VinceAngelo — Fri, 25 Oct 2013 11:17:09 GMT

The best way to clear metadata about dropped tables is to create a nominal table
with the same name ("CREATE TABLE oops (objectid INTEGER NOT NULL)"), then
to delete it with ArcCatalog. I've worked with ArcSDE since SDBE 1.2.1, and this
is the way I clear metadata after creation scripting has done horribly wrong.

- V