Working with SQL

Generating a PDM produces SQL code for your target DBMS. PowerDesigner provides tools to change and preview SQL code during PDM development. These tools are:

The SQL editor allows you to define queries and the SQL preview allows you to see a SQL query script before it is generated.

• Defining Queries with the SQL Editor
  You can use the editing features of the SQL Editor to define a query. The SQL Editor dialog box is divided into specific panes containing the information shown below:
• Previewing SQL Statements
  The Preview tab shows an SQL query script before it is generated. The displayed script reflects the options selected in the Database Generation dialog box. This script cannot be modified.

---

Created October 7, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com