topic Re: Table Appearing in SDE, but deleted from SQL Server in Geodatabase Questions

Table Appearing in SDE, but deleted from SQL Server

PeterKT — Mon, 22 Feb 2021 23:48:04 GMT

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

Re: Table Appearing in SDE, but deleted from SQL Server

VishApte — Tue, 23 Feb 2021 00:28:06 GMT

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

Re: Table Appearing in SDE, but deleted from SQL Server

PeterKT — Tue, 23 Feb 2021 03:23:36 GMT

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.

Re: Table Appearing in SDE, but deleted from SQL Server

ElaineBryant — Wed, 09 Apr 2025 16:21:56 GMT

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.

Re: Table Appearing in SDE, but deleted from SQL Server

George_Thompson — Wed, 09 Apr 2025 17:45:18 GMT

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

Re: Table Appearing in SDE, but deleted from SQL Server

ElaineBryant — Wed, 09 Apr 2025 17:47:15 GMT

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

Re: Table Appearing in SDE, but deleted from SQL Server

George_Thompson — Wed, 09 Apr 2025 18:15:38 GMT

Yeah that may be best for this type of issue.