Removing unused fields from database
This tip describes a procdure for removing unused fields from database.
Very often when you are developing a database you create some fields and afterwards you realize you don't need that field. When creating a view you will see that the name of that field is still in the field selection. In stead of making a new copy of that database you can use an easy way to remove these fields : use the COMPACT -C option.
load compact mydatabase.nsf -C