Link to home
Create AccountLog in
Avatar of willa666
willa666Flag for United States of America

asked on

rename all table prefixes

Hiya

I have a database that all teh tables have a prefix.

what is the best way to rename all the prefixs at once?

from pf1_ to pf2_

Ww
ASKER CERTIFIED SOLUTION
Avatar of cyberkiwi
cyberkiwi
Flag of New Zealand image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of willa666

ASKER

hi cyberkiwi

that query just seems to create a new table
no sure how that happens, since the only statement in there is a "rename table .... list"
Can you recheck results?