Trigger to delete Student Marks record when Student record is deleted.

Create Trigger DeleteStudentMarks on Student

after Delete

as

begin

delete from marks where id in (Select id from deleted )

end