(Not looking at the SDE inner tables but at the numbered tables/SPs)
I am not really an expert on the feature layer structure but any person that opens SQL Server management will probably see that in addition to the feature layer you get a bit of extra baggage:
This was after I created one point layer named UNIT_TEST.
And this is after deleting that layer – see anything wrong?
Yes, the SDE doesn't save the geometry inside the table but uses the numbered f/i/s tables and SPs.
Tip: If you are using SQL Server Management be sure to set a filter to tables/SPs by:
This is the best settings I could find:
Name | Does not contain | 1
Only because "1" will be used the most.
