Mosaic Dataset Leftover System Tables

Question

We used the following process to properly delete a Mosaic Dataset, either Source or Derived. First ran the 'Remove Rasters From Mosaic Dataset' tool with 'OBJECTID>=0' query. Then ran the 'Delete Mosaic Dataset' tool (DELETE_OVERVIEW_IMAGES, DELETE_ITEM_CACHE). After both tools execute successfully, the Mosaic Dataset System Tables do not get deleted, but rather they are now accessible through Catalog. We are using an SQL Server Enterprise Geodatabase.

Should we just Delete the Tables manually? Is this expected (and safe) or are we missing something that would automate the procedure?

Thanks a lot

danretired · Answer

Not sure, but if it happens again, remove the mosaic from any map first prior to deleting to see if the tables get removed when delete actually occurs

InfodimGIS · Answer

Thank you for the swift response. Apparently nothing else seems to be using the data. Apart from the current ArcGIS Pro session,  that is. The Mosaics were open in Pro when the Delete Mosaic Dataset Tool executed. I thought this would not be a problem since the tool was called from inside the same Pro session. But the mosaic layers remained in the table of contents, just lost the data underneath, acquiring a 'broken data source' red exclamation mark. Could this create the issue?

Or else, could it be that this is a database maintenance issue?

A Pro/Machine reboot had no effect on the tables being there. I can read them from both Pro and SSMS.

danretired · Answer

strange since

Delete (Data Management)—ArcGIS Pro | Documentation

* Deleting a mosaic dataset will only delete the mosaic dataset. To delete a mosaic dataset in its entirety, including any tables in the database and, optionally, any overviews or caches created with it use the Delete Mosaic Dataset tool.

Were the tables still there after a reboot?  Is anything else using the data?