Power Designer.
来源:互联网 发布:cygwin 与 linux 编辑:程序博客网 时间:2024/05/13 14:26
Power Designer 使用:
一.生成sql 2k的扩展属性(说明性字段):
1.首先表pd里的表general选项中要分配一个owner.
2.双击columns页中的字段,在commnet里填写字段说明
3.在preview页里,点击show generation option (ctrl+W),在Columns里,选上Comment后.确定
4.在preview里,就可以看到如以下生成说明性文字的语句
execute sp_addextendedproperty 'MS_Description',
'主键','user', 'dbo', 'table', 'FilesList', 'column', 'id'
go
一.生成sql 2k的扩展属性(说明性字段):
1.首先表pd里的表general选项中要分配一个owner.
2.双击columns页中的字段,在commnet里填写字段说明
3.在preview页里,点击show generation option (ctrl+W),在Columns里,选上Comment后.确定
4.在preview里,就可以看到如以下生成说明性文字的语句
execute sp_addextendedproperty 'MS_Description',
go
二.逆向工程
- Power Designer.
- Power Designer
- power designer
- power designer
- Power Designer杂记
- Power Designer杂记
- Power Designer杂记
- Power Designer杂记
- Power Designer 使用笔记
- Power Designer杂记
- Power Designer数据库建模
- Power Designer杂记
- power Designer 使用步骤
- Power Designer使用
- Power Designer 概述
- Power Designer使用技巧
- Power Designer使用技巧
- Power Designer使用技巧
- 数据泵导出导入(EXPDP和IMPDP)
- Windows PowerShell Cookbook: for Windows, Exchange 2007, and MOM V3
- Programming ASP.NET AJAX: Build rich, Web 2.0-style UI with ASP.NET AJAX [ILLUSTRATED]
- 服务器事件查看
- Excel 2007 PivotTables and PivotCharts
- Power Designer.
- CCIE Routing and Switching Exam Certification Guide
- Photography Foundations for Art and Design, Fourth Edition: The creative photography handbook
- Photoshop Elements 5 Workflow: The Digital Photographer's Guide
- Model-Driven Testing: Using the UML Testing Profile
- 比赛评分公开展示系统_[评委计分系统v3-双屏标准版]与[评委计分系统v3-双屏专业版]的差异
- 决定
- MySQL Pocket Reference: SQL Functions and Utilities
- Pro SQL Server 2005 Integration Services