TR_APPUSER_EMAILUPDATED

            create trigger dbo.TR_APPUSER_EMAILUPDATED on dbo.APPUSER after update not for replication
            as
            begin
                if update(EMAILADDRESS) begin
                    delete from dbo.APPUSERCLAIMS from INSERTED  where APPUSERCLAIMS.APPUSERID = INSERTED.ID and APPUSERCLAIMS.EMAILADDRESS <> INSERTED.EMAILADDRESS;
                end
            end