/***************************************
                *TASK 6*
 ***************************************/

CREATE TRIGGER trg_delete_from_vw_shipments
 ON dbo.vw_shipments
 INSTEAD OF DELETE
 AS
    DELETE FROM dbo.shipment_line
    WHERE shipment_id in (SELECT [shipment no] from deleted)
    DELETE FROM dbo.shipment
    WHERE shipment_id in (SELECT [shipment no] from deleted)
GO

--delete from vw_shipments where [shipment no] = 3