The PowerDesigner SQL Editor provides syntax coloring and tools to help you write SQL code.
You may need to write SQL code in order to:
Specifying a view query (see Working with View Queries)
Writing a procedure or trigger (see Triggers and Procedures)
Define a computed column (see Creating a Computed Column)
Insert scripts at the beginning and/or end of database or table creation (see Customizing Scripts)
The SQL Editor dialog box is divided into three panes with a toolbar across the middle:
Instead of hard coding the names of tables, columns, and other objects in your SQL statements, you can use the PowerDesigner Generation Template Language (GTL) or the PDM variables and macros to obtain these values from the model.
While you can perform many tasks using the PDM variables and macros, the GTL is more powerful, as it allows you to access any information about any object in the model.
For detailed information about GTL, see Customizing and Extending PowerDesigner > Customizing Generation with GTL .