Каскадное удаление и триггеры

Create Trigger FoundPair
On Clients
For Delete
AS  
    Insert into ClientPairs(Clients.Name, Clients.Surname, Clients.Patronymic, 
                Clients.Gender, Clients.ID_City, Clients.Skin_Colour, Clients.Photo_Path)
    Select Deleted.Name, Deleted.Surname, Deleted.Patronymic,
            Deleted.Gender, Deleted.ID_City, Deleted.Skin_Colour, Deleted.Photo_Path
    From Deleted
go
Create Trigger FoundPairCharact
On Characterist
After Delete
AS
    Insert into ClientPairsCharact(Client_ID, Height, Client_Weight, Hair_Colour, Profession, Salary, Hobby, WishOrNot)
    Select Deleted.Client_ID, Deleted.Height, Deleted.Client_Weight, Deleted.Hair_Colour,
            Deleted.Profession, Deleted.Salary, Deleted.Hobby, Deleted.WishOrNot
    From Deleted
go
Delete From Clients
Where Clients.ID = 16

Create Trigger FoundPair
On Clients
For Delete
AS  
    Insert ClientPairs(Name, Surname, Patronymic, Gender, ID_City, Skin_Colour, Photo_Path)
    Select Name, Surname, Patronymic, Gender, ID_City, Skin_Colour, Photo_Path
    From deleted
go
Create Trigger FoundPairCharact
On Characterist
For Delete
AS
    Insert ClientPairsCharact(Client_ID, Height, Client_Weight, Hair_Colour, Profession, Salary, Hobby, WishOrNot)
    Select Client_ID, Height, Client_Weight, Hair_Colour, Profession, Salary, Hobby, WishOrNot
    From deleted
go
Delete Clients
Where Clients.ID = 16