--sql server给表加说明:
--banner
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Banner' ,
@level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Banner'
--News 资讯
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'资讯' ,
@level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'News'
--列名加说明:
--banner [Id]:Id主键
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Id主键' ,
@level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Banner',
@level2type=N'COLUMN',@level2name=N'Id'