TR_RECOGNITIONLEVELAMOUNT_RECOGNITIONLEVEL (Trigger)

                 
                CREATE trigger TR_RECOGNITIONLEVELAMOUNT_RECOGNITIONLEVEL on dbo.RECOGNITIONLEVELAMOUNT after delete 
                as begin
                    declare @COMMONRECOGNITIONLEVELID uniqueidentifier;
                    select @COMMONRECOGNITIONLEVELID=RECOGNITIONLEVELID from DELETED;
                    if not exists
                        ( select RLA.RECOGNITIONLEVELID 
                          from dbo.RECOGNITIONLEVELAMOUNT RLA 
                          where RLA.RECOGNITIONLEVELID=@COMMONRECOGNITIONLEVELID 
                        )
                    begin
                        raiserror ('This minimum recognition amount is linked with a recognition level and cannot be deleted.',13,1)
                        rollback tran;
                    end
                end