34,591
社区成员
发帖
与我相关
我的任务
分享怎样用SQL外键约束
本人想直接用sql创建外键但是创建的外键默认级联删除和级联修改是不选的，但是我想直接用sql使级联删除和修改钩上，请问哪位大哥有解决的办法？
...全文
请发表友善的回复…
发表回复
rouqu 2004-12-10
- 打赏
- 举报
CREATE TABLE order_part
(
order_nmbr int,
part_nmbr int FOREIGN KEY REFERENCES part_sample(part_nmbr) ON DELETE NO ACTION,
qty_ordered int
)
NO ACTION specifies that the deletion fails with an error.
CASCADE specifies that all the rows with foreign keys pointing to the deleted row are also deleted.
(
order_nmbr int,
part_nmbr int FOREIGN KEY REFERENCES part_sample(part_nmbr) ON DELETE NO ACTION,
qty_ordered int
)
NO ACTION specifies that the deletion fails with an error.
CASCADE specifies that all the rows with foreign keys pointing to the deleted row are also deleted.
xq_zz 2004-12-10
- 打赏
- 举报
自己顶下，没有人知道吗？？
