Project Browser

The Project Browser task is an advanced option for querying your project using standard SQL syntax. This task can be used to extract data from your project and repair data if needed.

---

Execute Query

The Execute Query button will run the query entered on the open project. The data will display below the query and Snippet windows. If there is an error in your SQL statement, it will display in the status bar below the Results window.

To see a list of tables in your project, type "show tables" and click the Execute Query button. To see a description of a table, type "desc [table name]" and click the Execute Query button.

Save Results

The Save Results button will save the current results being displayed to a CSV file. You can then use this file in other programs that accept CSV formatted data.

Save Query

The Save Query button is used to save the current query being displayed. If you are running the same query multiple times, you can save it for future use. Use the Delete button to remove the current query from the saved list.

Snippets

The Snippets window hold reusable SQL code snippets. Select the text of the snippet you want to save and drag it to the snippet list. To use a snippet, place the cursor where the snippet should be inserted and double-click the snippet in the list.