How to Check if Tables aren't being used?

[benvatvandata]

Hi,

I am trying to reduce the database size and increase the server performance by finding and removing any tables that aren't being used in reports/sheets/objects/etc... is there a quick way of doing this besides manually going through each sheet and checking what fields are being used in each object?

Thanks in advance,

Ben

[rwunderlich]

Hi Ben,

I've run DA against some very large documents but I have seen (and fixed when I can) problems when there are many thousands of sheet objects.

Re reduced data.  After making selections, you must use the menu commands, File, Reduce Data, Keep Possible Values  and then save a reduced copy.

-Rob