How can I retrieve a deleted text

If you have not turned on iCloud Messages and if the message in question is in your last backup you can restore your iPhone from that backup. You will lose any data added since the time/date of that backup. Restore your iPhone, iPad, or iPod touch from a backup - Apple Support

Then it is gone.