Tag: powerDesign预览模式: 普通 | 列表

powerDesign生成外键问题

alter table jobs
   add constraint FK_JOBS_REFERENCE_COMPANYK foreign key (userid)
      references companykk (id)
      on update restrict
      on delete restrict


REFERENCES 子句只支持如下 ON Delete 和 ON Update 子句:
[ ON Delete { CASCADE | NO ACTION } ]
[ ON Update { CASCADE | NO ACTION } ]



 on update restrict
      on delete restrict
改成
 on update CASCADE
      on delete CASCADE

Tags: powerDesign

分类:网络技术 | 固定链接 | 评论: 0 | 引用: 0 | 查看次数: 969