The following SELECT statement shows the number of deletes occurring on a particular object:
SELECT DeleteCount FROM DBC.DeleteUseCountV WHERE DatabaseName = 'Personnel' AND ObjectName = 'Employee';
Result:
DeleteCount -------------------------- 4
The following SELECT statement shows the number of deletes occurring on a particular object:
SELECT DeleteCount FROM DBC.DeleteUseCountV WHERE DatabaseName = 'Personnel' AND ObjectName = 'Employee';
Result:
DeleteCount -------------------------- 4