This is a post I’m digging up from an old blog of mine, but refreshed. I needed to remove the table prefix from an existing Drupal site. The site had tables in the form of
drup_TABLENAME and needed to be in the standard Drupal format as
TABLENAME. I wrote a quick php script which can be called from Drush.