Working with SQL Statements in PowerDesigner

Each object that you create in your model is associated with SQL code that can be used to create or modify it in your database schema, and which is displayed on the Preview tab of its property sheet. Certain objects also require that you write your own custom SQL statements.

• Previewing SQL Statements
  Click the Preview tab in the property sheet of the model, packages, tables, and various other model objects in order to view the code that will be generated for it.
• Writing SQL Code in the PowerDesigner SQL Editor
  The PowerDesigner SQL Editor provides syntax coloring and tools to help you write SQL code.
• SQL Editor Tools
  The following tools are available in the SQL Editor and in dialogs containing the editor, such as trigger and procedure property sheet Definition tabs.
• Writing SQL using GTL
  You can use the PowerDesigner Generation Template Language (GTL) to write SQL statements.
• Writing SQL using PDM Variables and Macros
  You can use PDM variables and macros to write SQL statements.