Trigger to delete records in a linked table?

Question

SQL Server

Table Students

table Marks

You need to create a delete trigger that, when a student is deleted, deletes all of their grades.

Answer 1

You need to create a delete trigger

Not necessary.
Do a cascade delete. For example:

ALTER TABLE [dbo].[PerformerGenre]
    WITH NOCHECK ADD CONSTRAINT [FK_PerformerGenre_Genre] FOREIGN KEY([Genre])
  REFERENCES [dbo].[Genre] ([ID])
  ON DELETE CASCADE

required in coursework

CREATE TRIGGER deleted_otmetki ON student FOR DELETE
AS 
DELETE FROM otmetki WHERE otmetki.kod_studenta = deleted.kod_studenta
GO

Guide .