PowerDesigner can use variables in the generation and reverse-engineering of views.
|
Variable |
Comment |
|---|---|
|
%VIEW% |
Generated code of View |
|
%VIEWNAME% |
View name |
|
%VIEWCODE% |
View code |
|
%VIEWCOLN% |
List of columns of View. Ex: "A, B, C" |
|
%SQL% |
SQL text of View. Ex: Select * from T1 |
|
%VIEWCHECK% |
Contains Keyword "with check option" if this option is selected in View |
|
%SCRIPT% |
Complete view creation order. Ex: create view V1 as select * from T1 |