create trigger delbookinfo
on bookinfo
after delete
as
delete from UFavoritesInfo
where fbid in (select bid from deleted)bookinfo的BID是主键
UFavoritesInfo的Fbid是外键引用的bid删除bookinfo中的数据库时触发删除UFavoritesInfo数据为什么会提示主外健约束呢??、应该怎样写呢?
on bookinfo
after delete
as
delete from UFavoritesInfo
where fbid in (select bid from deleted)bookinfo的BID是主键
UFavoritesInfo的Fbid是外键引用的bid删除bookinfo中的数据库时触发删除UFavoritesInfo数据为什么会提示主外健约束呢??、应该怎样写呢?
CONSTRAINT [name of foreign key] FOREIGN KEY ([column name]) REFERENCES [dbo].[REFERENCE table name] ([REFERENCE column name]) ON DELETE CASCADE
end
----> PS: ON DELETE CASCADE 级联删除.
----> ON DELETE SET NULL 级联置空.
----> ON UPDATE CASCADE 更新删除.
----> ON UPDATE SET NULL 更新置空.