免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 1582 | 回复: 0
打印 上一主题 下一主题

powerdesigner : To designate an alternate key [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2007-01-24 15:48 |只看该作者 |倒序浏览
To designate an alternate key:
1 Double-click a table in the diagram.
The property sheet for the table appears.
2 Click the Keys tab.
The Keys page appears. It lists keys defined for the table.
3 Click a blank line in the list.
or
Click the Add a Row tool.
An arrow appears at the beginning of the line.
4 Type a key name and a key code.
Alternate key naming convention  
The naming convention for an alternate key is AK followed by the number of the key column code; for example AK1_CUSNAME.
5  Type a constraint name in the Constraint Name column.
If you do not specify a constraint name, PowerDesigner creates a default constraint name automatically.
Display the column you need  
If you do not see the column you need, display it with the Customize Columns and Filter tool. See the Defining a filter on a list section in the General Features Guide.
6 Click Apply.
The constraint name and code are committed.
7 Click the new key name.
An arrow appears at the beginning of the line.
8 Click the Properties tool.
The property sheet for the new key appears.
9 Click the columns tab.
The columns page appears. It lists all columns defined for the key. At key creation, the list is empty.
10 Click the Add Columns tool.
A list of columns, defined for the table appears. This list does not include primary key columns.
11 Select check boxes for one or more columns that you want to designate as alternate key columns.
12 Click OK in each of the dialog boxes.

本文来自ChinaUnix博客,如果查看原文请点:http://blog.chinaunix.net/u/4572/showart_237223.html
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP