PowerDesigner generate annotated SQL versions generic 10 (12, 15)

Do database design is the most distressing thing is to use powerdesigner tools to design the database to execute the SQL file without comments, then how to let PowerDesigner design has comments, the bottom teaches you a stupid method, although the method is stupid, but can achieve the effect.

Under the physical model

Action:Database-to-Edit current DBMS, enter page,

Then separate the

Script--Objects--and Table-to-tablecomment

Script--Objects--columncomment

The values in value are modified to

ALTER TABLE [%qualifier%]%table% comment%.60qa:comment%

ALTER TABLE [%qualifier%]%table% modify column%column%%datatype% comment%.60qa:comment%

PS: The principle of this approach is to modify the annotations in the way that comment describes the command. Of course, the best way is to modify the table or column of the add script, because did not understand the script's wording, so here only to show you how to change, specific changes in the law is also hope that we realize after the generous.

PowerDesigner generate annotated SQL versions generic 10 (12, 15)