How do you delete unused fields from a database? I have a large database that has a considerable amount of fields that have been deleted and are no longer used. How do you go about cleaning these up?
Subject: Deleting Unused Fields from Database
Compact is supposed to do it, though peoiple have reported problems.
Subject: Yes, run agent, then compact
but if there is a reference to a field in an old formula somewhere, or any mention of it anywhere in the design, they won’t all really go away completely. good luck - not so easy to do if you have a lot of forms, views, columns, agents, etc.
Subject: RE: Yes, run agent, then compact
what is this compact that you speak of?
Subject: RE: Yes, run agent, then compact
You can compact a database either by using the button in the database properties, or by using the server task. For details of how to use the database properties, look for Databases\Compacting in the index of the Notes client help database. For details of how to use the server task, look for Compacting\Databases in the index of the Administration Help database.
Subject: Deleting Unused Fields from Database
from an agent:
FIELD NameofYourField := @DeleteField;
SELECT @All
hth
Cathy