What are We doing?----我们在做什么

当前位置:资讯中心 - 技术讨论

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

10-01-20