database --- > edit current database...
general -> script-> object-> table-> table comment
添加:
[execute ]sp_addextendedproperty N'MS_Description',
N%.q:COMMENT%,
N'user', N'dbo', N'table', N%.q:TABLE%
同上 column -> columncomment
添加
[execute ]sp_addextendedproperty N'MS_Description',
N%.q:COMMENT%,
N'user', N'dbo', N'table', N%.q:TABLE%, N'column', N%.q:COLUMN%
同时在生成的时候把注释的选项 打上勾