powerdesinger（MSSQLSRV2008测试通过）通过Name或comment 导出注释到sql脚本，生成sql的说明备注，包括表注释信息

导出字段信息name注释到sql2008字段的说明

在database -> edit current dbms -> 

MSSQLSRV2008::Script\Objects\Column\ColumnComment

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'%COMMENT%', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name= %COLUMN% ,@level2type=N'COLUMN',@level2name= %.60qA:COMMENT%

导出表注释信息name注释到sql2008表的说明 

在database -> edit current dbms -> 

MSSQLSRV2008::Script\Objects\Column\ColumnComment

 

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'%COMMENT%', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'table',@level1name=%.60qA:COMMENT%

信息来自原创，转载请说明出处。谢谢合作！