Categories

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

NEWS & TECH BLOG

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

Share