数据库SQL级联删除、更新:
CREATE TABLE t1(id INT PRIMARY KEY,name VARCHAR(10))
CREATE TABLE t2(id INT REFERENCES t1(id )ON DELETE CASCADE ON UPDATE CASCADE,AGE TINYINT)
数据库ORACLE级联删除:
CREATE TABLE t1(id INT PRIMAY KEY,name VARCHAR(10))
CREATE TABLE t2(id INT REFERENCES t1(id )ON DELETE CASCADE,AGE NUMBER(2,0) )
添加级联操作
Alter table BorrowI add constraint FK_Bno
foreign key (Bno)references ReaderI(Bno) ON DELETE CASCADE ON UPDATE CASCADE
Alter table BorrowI add constraint FK_Tno
foreign key (Tno)references BookI(Tno) ON DELETE CASCADE ON UPDATE CASCADE