CREATE PROCEDURE [dbo].[MssWebDeleteInternationalContainer]
    @inOrdersFID int,
    @inInternationalContainerID int
as
begin
    set nocount on

    --Set Forign-key to NULL of this containerId in InternationalLiftVan if exists before deleting to persist Referential Integrity
    update InternationalLiftVan set
        InternationalContainerFID = null
    where OrdersFID = @inOrdersFID and InternationalContainerFID = @inInternationalContainerID
    
    delete from InternationalContainer
    where OrdersFID = @inOrdersFID and InternationalContainerID = @inInternationalContainerID

end
GO
GRANT EXECUTE ON  [dbo].[MssWebDeleteInternationalContainer] TO [MssExec]
GO