SQL Utility

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

Using Stored Procedures in SQL Utility

Sample SQL Statements