powerdesigner V11；MsSqlServer7.0,2000逆向默认值名称不过来BUG

 修改方法如下：

Tools  >> Resources >> DBMS >> Mircosoft SQL Server7.X/Mircosoft SQL Server 2000

修改属性：Script >> Objects >> Columns  >>

Create：

alter table [%QUALIFIER%]%TABLE%
   add %COLUMN% [%COMPUTE%?AS (%COMPUTE%):%DATATYPE%[.Z:[%IDENTITY%? %IDENTITY%[[(%ExtIdentitySeedInc%)][%ExtIdtNotForReplication%? not for replication]]:[%ExtNullConstName%? constraint %ExtNullConstName%][ %NULL%][ %NOTNULL%]][[%ExtDeftConstName%? constraint %ExtDeftConstName%] default %DEFAULT%]]
   [%CONSTDEFN%]]

SqlListQuery：

{OWNER, TABLE, S, COLUMN, DTTPCODE, LENGTH, SIZE, PREC, COMPUTE, NOTNULL, IDENTITY, DOMAIN, DEFAULT, ExtIdentitySeedInc, ExtIdtNotForReplication, ExtDeftConstName}

select
   u.name,
   o.name,
   c.colid,
   c.name,
   case when (s.usertype < 100) then s.name else x.name end,  
   c.prec,
   c.length,
   c.scale,
   z.text,
   case (c.status & 8) when 8 then 'NULL' else 'NOTNULL' end,
   case (c.status & 128) when 128 then 'identity' else '' end,
   case when (s.usertype < 100) then '' else s.name end,
   case (v.text) when '('''')' then '~''''~' else v.text end,
   case (c.status & 128) when 128 then
        convert(varchar(10), ident_seed(u.name + '.' + o.name))
      + ', '
      + convert(varchar(10), ident_incr(u.name + '.' + o.name))
   else '' end as coln,
   case (c.colstat & 9) when 9 then 'true' else 'false' end,
   d.name
from
   dbo.sysusers u
      join dbo.sysobjects o on (o.uid = u.uid and o.type in ('U', 'S', 'V'))
      join dbo.syscolumns c on (c.id = o.id)
      left outer join dbo.systypes s on (c.usertype = s.usertype and s.xtype = c.xtype and c.usertype >= 0)
      left outer join dbo.systypes x on (s.usertype > 100 and s.xtype = x.xtype and x.usertype not in (0, 18, 80) and x.usertype < 100)
      left outer join dbo.syscomments z on (z.id = o.id and z.number = c.colid)
      left outer join dbo.sysobjects d on (d.id = c.cdefault and d.category <> 0)
      left outer join dbo.syscomments v on (v.id = d.id)
where 1 = 1  
[  and u.name = %.q:OWNER%]
[  and o.name=%.q:TABLE%]
order by 1, 2, 3