To automatically generate a SQL query for an individual table:
- Select a table in the DB Structure view. Right-click to display the context menu.
- Choose Generate Select in SQL Editor. The SQL Editor opens with a SELECT statement that contains all the columns of the table.
-
Click Execute SQL
to execute the query. The results appear in a browse in the SQL Results view.
Note: If you select a table whose field names begin with an underscore (as is the case in a system table), you need to ensure that every field name is enclosed in quotes. Otherwise, the SQL statement fails. You can modify the Progress DB Navigator preferences so that Copy To Clipboard has the Enclose in single quotes option selected to ensure that all field names are quoted.