Batch renaming of tables

[eagles9999]

Is there any way to rename a batch of tables in my database.

For example....

Suppose I have 50 or so tables and they use a naming convention such as

LMS_EMPLOYEE
LMS_APPLICATION
LMS_ROLE
LMS_HISTORY
etc etc etc

And I want to rename them all to

PREFIXLMS_EMPLOYEE
PREFIXLMS_APPLICATION
PREFIXLMS_ROLE
PREFIXLMS_HISTORY
etc etc etc

Is there any simple way of doing that without having to rename them all individually by hand?

Thanx

[siuha]

We are sorry that Navicat does not support your mentioned feature. Your request has been forwarded to our development team. We will keep improving our Navicat in the future.

[eagles9999]

Thanx.

Look forward to seeing that feature in future version