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.