SQL SERVER里给表，字段添加注释
来源：互联网 发布：java调用lua脚本 编辑：程序博客网 时间：2024/05/23 00:20
-- 表加注释EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'注释内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'表名'-- 字段加注释EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'注释内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'表名', @level2type=N'COLUMN',@level2name=N'字段名'
例：
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'申请单号' , @level0type=N'SCHEMA',@level0name=N'AdminService', @level1type=N'TABLE',@level1name=N'BusinessTripInfomationNumber', @level2type=N'COLUMN',@level2name=N'Number'GOEXEC sys.sp_addextendedproperty @name=N'CnName', @value=N'出差申请单号' , @level0type=N'SCHEMA',@level0name=N'AdminService', @level1type=N'TABLE',@level1name=N'BusinessTripInfomationNumber'GO
