如何从表中删除Handel与另一个表有关系 [英] How can Handel Delete from Table have a relationship with another Table

问题描述

我有两张桌子



&

第一张表：

i have two tables

&
First Table :

GuestId    Name     Delete
1            Magdy    Delete
2            Rana     Delete
3            Yousf    Delete

第二张表：

Second Table :

Bookingid  GuestId           Place
1             1              Paris     Delete
2             1              Amedica   Delete
3             1              Romanya   Delete

2张桌子之间有关系

Guest 1 - >有3个预订

但是

来宾2 - >没有任何书（很容易删除）



请

当我要删除第二个表中的任何行时没问题

但

当我想从第一个表中删除行时&安培;这一排预订在第二张桌子

i想告诉我（你不能删除这一行，你必须先删除所有预订）



任何人都可以帮助我

there are relations between 2 tables
Guest 1 --> Have 3 Booking
but
Guest 2 -->Haven't any book (its easy to delete)

please
when i want delete any row in Second table its no problem
but
when i want to delete row from first table & this row have booking in second table
i want to tell me that (you cant Delete this Row, you Must delete all booking at first)

any one can help me please

推荐答案

当然，如果你想要删除第一个表中的行，你必须删除第二个表中的所有相关行。 br />


但是在sql server中你可以激活外键上的级联删除

Hi yes of course if you want to delete row in the First Table you Must delete all related rows in the second Table.

But in sql server you can activate cascade delete on the foreign key

这篇关于如何从表中删除Handel与另一个表有关系的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！