使用PowerDesigner导入表+PowerDesigner画ER图+PowerDesigner设置外键

①ER图：就是PD中的 Physical Diagram

一、导入表，并设置备注为PD中的显示名称

参考：https://blog.csdn.net/weixin_37530941/article/details/107331105
利用建表语句sql导入表

1、新建数据库模型

2、导入表——见参考

最好每张表都把生成主键的名字修改了，不然会产生错误的字段

-- 建表语句1_未修改前的CREATE TABLE "TABLE_1"("COLUMN_11" CHAR(10),"ID" CHAR(32) NOT NULL,"AGE" NUMBER(22,6),"C_2222" CHAR(10),UNIQUE("AGE"),NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON COLUMN "TABLE_1"."AGE" IS 'CS_AA';COMMENT ON COLUMN "TABLE_1"."COLUMN_11" IS 'CS_11';COMMENT ON COLUMN "TABLE_1"."C_2222" IS 'CS_';COMMENT ON COLUMN "TABLE_1"."ID" IS 'CS_DD'; -- 建表语句2_修改之后的-- 主键的名字规则：PK_表名CREATE TABLE "TABLE_1"("COLUMN_11" CHAR(10),"ID" CHAR(32) NOT NULL,"AGE" NUMBER(22,6),"C_2222" CHAR(10),UNIQUE("AGE"),constraint PK_CS1 PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON COLUMN "TABLE_1"."AGE" IS 'CS_AA';COMMENT ON COLUMN "TABLE_1"."COLUMN_11" IS 'CS_11';COMMENT ON COLUMN "TABLE_1"."C_2222" IS 'CS_';COMMENT ON COLUMN "TABLE_1"."ID" IS 'CS_DD';

修改详情：

脚本
- 使用字段备注当做pd中的显示名的脚本

Option Explicit ValidationMode = True InteractiveMode = im_Batch Dim mdl ' the current model ' get the current active model Set mdl = ActiveModel If (mdl Is Nothing) Then MsgBox "There is no current Model " ElseIf Not mdl.IsKindOf(PdPDM.cls_Model) Then MsgBox "The current model is not an Physical Data model. " Else ProcessFolder mdl End If Private sub ProcessFolder(folder) On Error Resume Next Dim Tab 'running table for each Tab in folder.tables if not tab.isShortcut then tab.name = tab.comment Dim col ' running column for each col in tab.columns if col.comment="" then else col.name= col.comment end if next end if next Dim view 'running view for each view in folder.Views if not view.isShortcut then view.name = view.comment end if next ' go into the sub-packages Dim f ' running folder For Each f In folder.Packages if not f.IsShortcut then ProcessFolder f end if Next end sub