sql server 给表加说明，给列字段加说明

--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'

 

转载于:https://www.cnblogs.com/SeNaiTes/p/9041085.html

相关资源：JAVA上百实例源码以及开源项目