nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Table Appearing in SDE, but deleted from SQL Server

PeterKT

We have tables appearing within ArcGIS Pro, SDE connection that no longer exist within the SQL Server connection.

Deleting the tables while in ArcGIS Pro removes them, but when we refresh the connection they are still there.

I suspect there was an issue when copying up these large tables and they were deleted from the SQL Server connection, but left registered in SDE.

Is there any way we can clear those tables from SDE?

The SQL Server is an AWS RDS and we might getting some mirroring causing the problem.

Thanks

Find more posts tagged with

Accepted answers

VishApte

It looks like tables were dropped directly in SQL Server. When a table is dropped using ArcGIS Pro or Catalog, it deletes lot of metadata entries, typically, GDB_ITEMS, SDE_TABLE_REGISTRY, SDE_COLUMN_REGISTRY, "a" and "d" tables for versioning etc.

If possible, try to create the table again with same structure using SQL statement and then delete the table using ArcGIS Catalog. Hopefully, Catalog will complete the workflow of table deletion without a rollback due to the missing table.

If you simply want these tables not appear in dataset tree, then delete the corresponding entries from SDE_TABLE_REGISTRY and GDB_ITEMS. See https://desktop.arcgis.com/en/arcmap/latest/manage-data/using-sql-with-gdbs/overview-geodatabase-system-tables.htm

and https://desktop.arcgis.com/en/arcmap/10.4/manage-data/geodatabases/registering-a-table-with-the-geodatabase.htm for some info.

NOTE: manual edits to metadata tables is a not recommended and can corrupt entire EGDB. So, take a backup before attempting anything.

Cheers,

Vish

All comments

ElaineBryant

i assume i should open a case with esri to figure it out.

George Thompson

This would point to the SDE schema still being present but the "data" schema is gone. This can corrupt the entire EGDB.

ElaineBryant

I had DBA drop an entire oracle schema but I still see it in Pro. For whatever reason, one schema was successfully removed from view, but the other 2 aren't. As far as oracle is concerned they don't exist.

PeterKT

Thanks Vish. That worked, recreating the tables with sql create table. In the end didn't use exact schema, just used OBJECTID and another dummy nvarchar. Seems to cleared both SDE and any references in the SDE tables.

VishApte

and https://desktop.arcgis.com/en/arcmap/10.4/manage-data/geodatabases/registering-a-table-with-the-geodatabase.htm for some info.

NOTE: manual edits to metadata tables is a not recommended and can corrupt entire EGDB. So, take a backup before attempting anything.

Cheers,

Vish

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.