SQL SERVERテーブルコメント、フィールドコメントの追加

--       
--Eg. execute sp_addextendedproperty 'MS_Description','      ','user','dbo','table','       ','column','        ';
execute sp_addextendedproperty 'MS_Description','add by liyc.      ','user','dbo','table','DiagRecord','column','DiagTypeCode'; --       execute sp_updateextendedproperty 'MS_Description','add by liyc.','user','dbo','table','DiagRecord','column','DiagTypeCode'; --       execute sp_dropextendedproperty 'MS_Description','user','dbo','table','DiagRecord','column','DiagTypeCode'; --       execute sp_addextendedproperty 'MS_Description','      ','user','dbo','table','DiagRecord',null,null; --       execute sp_updateextendedproperty 'MS_Description','      1','user','dbo','table','DiagRecord',null,null; --       execute sp_dropextendedproperty 'MS_Description','user','dbo','table','DiagRecord',null,null;


  ：https://www.cnblogs.com/xingyadian/p/10030793.html

転載先:https://www.cnblogs.com/binlyzhuo/p/11130682.html