Follow our news:

Follow canonburysvcs on Twitter Follow Canonbury Services on Facebook Follow Canonbury Services' news by RSS Follow Canonbury Services' news by Atom Follow Canonbury Services' news by email


Clean up your unused fields

03/05/2009 – in SQL queries

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