It will be seen on your client, not in explorer anymore since the tx may be not standard or rejected by mempool.
But where is it stored? It is done on the old client, if it is not visible in the network, how does it display on the new client?
I don't know if it's possible in other wallet, it can be done im Electrum wallet. In electrum, if you click the tx, there will be option to remove the tx.
It has no option to cancel the transaction if the transaction is made within 14 days, right?