SQL Tables Generated
Running an analysis generates a number of SQL Tables within the Server/Database in which the training data is located. All SQL tables have names starting with the Output Prefix and include:
Curve Modification Table
Factor Base Table
Factor (Characteristic) Table (one for each Characteristic)
Summary Factor Table
Summary Significance Table
Test Detail Table
Training Detail Table
In order to view analysis results at a later time (by opening the .cgmr file in Cognalysis MultiRate), these SQL Generated tables must still be available. If they are moved, renamed, or deleted the analysis will have to be re-run.
There is a way to delete in bulk the analysis tables that are generated in SQL if they are no longer needed. See the Delete SQL Analysis Tables section for more information.