I have a large group of database tables originally named with a prefix of "tblXYZ123-". I still want the tables to be prefixed as this keeps the related tables grouped together but I want to rename this group of tables by replacing the prefix with a simpler, more relevant prefix like "td".

How do I rename the tables without renaming each file manually? I'm hoping for a script or something but haven't been able to find such a tool.