CREATE TRIGGER tr_DeleteUsers
ON Users
FOR DELETE
AS
BEGIN

    DELETE FROM Messages
    WHERE UserId IN (SELECT d.Id FROM deleted AS d)

    DELETE FROM UsersChats
    WHERE UserId IN (SELECT d.Id FROM deleted AS d)

    DELETE FROM Users
    WHERE Id IN (SELECT d.Id FROM deleted AS d)

END