3

TLDR: You can't tell by just counting the A and D table records; you also need to know if the object was in the business (base) table as well. Objects from the base table which have not been modified before deletion have only an entry in the deletes table (Base, Delete) Objects which have never been posted to the base table would have the same number of ...


1

Modified from Jaime Burgos. The CROSS APPLY line had the parameter for Oracle. It is different in SQL as included below. SELECT i.Name AS FeatureClass ,xVal.value('Name[1]','nvarchar(max)') Field ,xVal.value('DomainName[1]', 'nvarchar(max)') Domain FROM GDB_ITEMS i JOIN GDB_ITEMTYPES it ON i.Type = it.UUID CROSS APPLY i.Definition.nodes('/*/...


Only top voted, non community-wiki answers of a minimum length are eligible