2010-11-10

PowerDesigner ColumnComment 筆記

變更 ColumnComment Script 筆記。

路徑:MSSQLSRV2000::Script\Objects\Column\ColumnComment

[%OWNER%?[.O:[execute ][exec ]]sp_addextendedproperty [%R%?[N]]'MS_Description', 
  [%R%?[N]]N%.q:COMMENT%,
  [%R%?[N]]'user', [%R%?[N]]%.q:OWNER%, 
  [%R%?[N]]'table', [%R%?[N]]%.q:TABLE%, 
  [%R%?[N]]'column', [%R%?[N]]%.q:COLUMN%
:declare @CurrentUser sysname
select @CurrentUser = user_name()
[.O:[execute ][exec ]]sp_addextendedproperty [%R%?[N]]'MS_Description', 
  [%R%?[N]]N%.q:COMMENT%,
  [%R%?[N]]'user', [%R%?[N]]@CurrentUser, 
  [%R%?[N]]'table', [%R%?[N]]%.q:TABLE%, 
  [%R%?[N]]'column', [%R%?[N]]%.q:COLUMN%
]

PowerDesigner

沒有留言: