Copy Code Trigger Definition 

      CREATE TRIGGER [dbo].trgDeleteContentFromCompletedComparisonTests
      ON  [dbo].SiteContent
      FOR DELETE
      AS
      BEGIN
      SET NOCOUNT ON;

      --Trigger

      DELETE FROM [dbo].ContentComparisons WHERE CID IN (SELECT [Id] FROM deleted)
      
      END