Deleting Fields
Deleting a Field from the Field Catalog removes it permanently from all Archives and will result in a loss of any data in that Field.
- To delete a Field, On the Field Catalog toolbar, click Fields.
- Click the More Options (
) icon for the selected Field. - Click Delete.
- Because this will permanently delete the Field, enter the displayed text in the Confirm Action prompt to proceed.
- Click Delete.
Behind the Scenes in SQL
On the SQL side, when you create the Field Catalog, a SQL table is created in which your documents’ index data is stored – all document records, no matter the Archive, are all stored in that single data table. When you create an Archive and choose to include a particular Index Field, you’re really just determining which Index Fields to expose in that Archive, because, in SQL, the document record will always have all Index Fields.
The benefit of this is that when a record is moved from one Archive to another, the index data is retained. Some data might not display in the destination Archive if all the same Index Fields aren’t exposed, but the data still exists in the SQL table. So, if you move the document back to its original Archive, all the data that was there originally is still available and displays, just as it did before you moved the document.