To invoke the Query Tool
SQL IDE from within PEM, simply highlight the name of the database you want to query in the tree control, and click the SQL toolbar icon. You can also open the Query Tool
IDE by selecting Query tool
from the Tools
The Query Tool
dialog provides an interface that allows you to manually enter in SQL queries, graphically create and execute SQL statements from dragging and dropping objects onto a visual palette, EXPLAIN
queries and much more.
The upper panel of the Query Tool
contains the SQL Editor. You can use the panel to manually enter a query, or read the query from a file. If you are manually entering a SQL query, the edit entry window also contains autocompletion code and formatting features that help you write queries.