The following SELECT statement shows the number of accesses occurring on an object:
SELECT AccessCount FROM DBC.ObjectUseCountV WHERE DatabaseName = 'Personnel' AND ObjectName = 'Employee';
Result:
AccessCount -------------------------- 16
The following SELECT statement shows the number of accesses occurring on an object:
SELECT AccessCount FROM DBC.ObjectUseCountV WHERE DatabaseName = 'Personnel' AND ObjectName = 'Employee';
Result:
AccessCount -------------------------- 16