When you’ve had GoldMine for a while, and added and deleted fields a few times, you might find that your custom fields list ends up containing a number of fields that are no longer used.

This SQL script will identify them for you. Simply run it from the SQL Query page within GoldMine itself.


select field_name, field_type, fielddesc from contudef where field_name like 'u%' and
field_name not in
(
select field_name from contudef where field_name in
(select fldname from fields5)
)
order by field_name