涛-x

导航

随笔分类 -  PowerDesigner

POWERDESIGNER 将名称(name)替换为注释(comment)
摘要：PowerDesigner->Tools->Execute Commands->Edit/Run Scripts 将comment覆盖name Option Explicit ValidationMode = True InteractiveMode = im_Batch Dim mdl ' the 阅读全文

posted @ 2020-03-28 16:13 涛-x 阅读(992) 评论(0) 推荐(0)

PowerDesigner 生成SQL Server 注释脚本
摘要：--生成数据表的注释EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=[%R%?[N]]%.q:COMMENT% , @level0type=N'SCHEMA',@level0name=[%R%?[N]]%.q:OWNER 阅读全文

posted @ 2019-10-11 14:57 涛-x 阅读(741) 评论(0) 推荐(0)

PowerDesigner 生成SQL Server 2005 注释脚本
摘要：--生成数据表的注释EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=[%R%?[N]]%.q:COMMENT% , @level0type=N'SCHEMA',@level0name=[%R%?[N]]%.q:OWNER 阅读全文

posted @ 2019-05-20 14:36 涛-x 阅读(352) 评论(0) 推荐(0)