Delete Inactive Records from CAD Relational Database

AccuMark can be configured through SQL Support to write to a CAD Relational Database. Statistical information for markers, models and its pieces is stored into various tables, along with thumbnail images for the markers and the model’s pieces.

Previously when SQL storage area markers, models and their pieces were deleted, and you had the CAD Relational Database configured, the relational database only marked the data items as InActive, but the records still existed in all the database tables. This caused for a lot of extra data in the tables that was no longer needed, and possibly making the querying or retrieving of data from the relational database more complicated and slow.

Remove the InActive records from the CAD Relational database:

“Delete inactive records” will remove all the entries in all the CAD Relational Database tables that have been identified as InActive for the currently configured database as set in SQL Support.