PowerDesigner使用

生成SQL column不含有collate chinese_prc_ci_as 

1.点击：工具栏-》database-》edit current DBMS

2.选择数据源(以SqlServer2005为例)      Microsoft SQLServer2005\Script\Objects\Column\Add

%20:COLUMN% [%COMPUTE%?AS [(]%COMPUTE%[)]:[%.L:DATATYPE%=xml?xml[%XMLSchemaCollection%?([%ContentType% ]%XMLSchemaCollection.GeneratedName%):                 ]:%20:DATATYPE%][%ExtRowGuidCol%? RowGuidCol][%IDENTITY%? %IDENTITY%[[(%ExtIdentitySeedInc%)][%ExtIdtNotForReplication%? not for replication]]:[%ExtNullConstName%? constraint %ExtNullConstName%][ %NULL%][ %NOTNULL%]][[%ExtDeftConstName%? constraint %ExtDeftConstName%] default %DEFAULT%]]
   [%CONSTDEFN%]

 

生成sql过滤表名

Name Not Equal _*

设置默认值时的引号问题

1.  工具栏--》Database-》Edit Current DBMS=》Script=>Sql=>Keywords=>ReservedDefault 添加对应默认值

2. 工具栏--》Database-》Edit Current DBMS=》Script=>Sql=>Syntax=>Quote 【Value设置为空】