PowerDesigner can use variables in the generation of databases, triggers, and procedures.
|
Variable |
Comment |
|---|---|
|
%DATE% |
Generation date & time |
|
%USER% |
Login name of User executing Generation |
|
%PATHSCRIPT% |
Path where File script is going to be generated |
|
%NAMESCRIPT% |
Name of File script where SQL orders are going to be written |
|
%STARTCMD% |
Description to explain how to execute Generated script |
|
%ISUPPER% |
TRUE if upper case generation option is set |
|
%ISLOWER% |
TRUE if lower case generation option is set |
|
%DBMSNAME% |
Name of DBMS associated with Generated model |
|
%DATABASE% |
Code of Database associated with Generated model |
%DATASOURCE% |
Name of the data source associated with the generated script |
|
%USE_SP_PKEY% |
Use stored procedure primary key to create primary keys (SQL Server specific) |
|
%USE_SP_FKEY% |
Use stored procedure foreign key to create primary keys (SQL Server specific) |