--为字段添加注释 --Eg. execute sp_addextendedproperty 'MS_Description','字段备注信息','user','dbo','table','字段所属的表名','column','添加注释的字段名'; execute sp_addextendedproperty 'MS_Description','字段含义','user','dbo','table','表名','column','字段名称'; --修改字段注释 execute sp_updateextendedproperty 'MS_Description','字段含义','user','dbo','table','表名','column','字段名称'; --删除字段注释 execute sp_dropextendedproperty 'MS_Description','user','dbo','table','表名','column','字段名称'; -- 添加表注释 execute sp_addextendedproperty 'MS_Description','表注释','user','dbo','table','表名',null,null; -- 修改表注释 execute sp_updateextendedproperty 'MS_Description','表注释','user','dbo','table','表名',null,null; -- 删除表注释 execute sp_dropextendedproperty 'MS_Description','user','dbo','table','表名',null,null;
标签:Description,dbo,sqlserver,注释,添加,user,表名,table From: https://www.cnblogs.com/wzf-Learning/p/17792795.html