The SQL Utility is a powerful tool that allows users to update fields in the GainSeeker database tables. There are three modes available for running this utility:
Standard mode- This mode protects the validity of the database by validating and limiting the fields that can be changed.
Freeform SQL- This mode is used for update queries and does not return the results. Validation checking is disabled.
Execute SQL- This mode can be used for all SQL queries and view the results of the executed query. Validation checking is disabled.
The Freeform SQL and Execute SQL modes are recommended for use by database administrators only.
More:
SQL Utility Standard Mode Example - renaming a standard
SQL Utility Standard Mode Example - deleting an unused defect
SQL Utility Freeform Mode Example
Using SQL Utility in Freeform Mode to rename a standard
SQL Utility Execute SQL Mode Example