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
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
Comment