CREATE TRIGGER tr_DeleteUsers
ON Users
FOR DELETE
AS
BEGIN

    DECLARE @UserId INT = (SELECT d.Id FROM deleted AS d)
    DELETE FROM Messages
    WHERE UserId = @UserId

    DELETE FROM UsersChats
    WHERE UserId = @UserId

    DELETE FROM Users
    WHERE Id = @UserId

END