sqlserver注释巧清理

生成表创建语句

Excel公式过滤EXEC sys.sp_addextendedproperty 
=IF(LEFT(A1,9)="EXEC sys.",A1,"")正则替换
EXEC sys.sp_addextendedproperty \@name=N'MS_Description', \@value=N'[^']+?' ,
EXEC sys.sp_dropextendedproperty \@name=N'MS_Description',  
 
删除数据库关系图
DELETE FROM sysdiagrams