CREATE TRIGGER PersonsDeleteDependents >> ON Persons >> FOR DELETE >>AS >>BEGIN >> -- SET NOCOUNT ON added to prevent extra result sets from >> -- interfering with SELECT statements. >> SET NOCOUNT ON; >> >> -- Insert statements for trigger here >> delete Persons >> from Persons >> inner join deleted on deleted.personid = persons.parentid >> >>END>>