生成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设置为空】