I've accidently named all my tables (100+) in my sql database with the prefix 2019_
Wasn't aware this was not a good idea until just now (just returned to SQL after 2 years)
Is there any way to bulk swap it to a suffix or even delete all the tables? I can't even seem to open them. Really don't want to go through them all manually.
Appologies if this is a silly question, potentially googling the wrong terms
Thanks!