drop tables with a certain prefix
How can i drop all tables with a certain prefix. I have 2 different applications in one database each with their own prefix?
How can i drop all tables with a certain prefix. I have 2 different applications in one database each with their own prefix?
pr0gr4mm3r posted this at 00:21 — 1st May 2007.
He has: 1,502 posts
Joined: Sep 2006
Do you have phpMyAdmin on your server?
benf posted this at 00:57 — 1st May 2007.
They have: 426 posts
Joined: Feb 2005
yes i do
pr0gr4mm3r posted this at 03:09 — 1st May 2007.
He has: 1,502 posts
Joined: Sep 2006
Sign into phpMyAdmin, select the database. You should see a list of tables. Check the tables you wish to delete, and then select drop from the list at the bottom of the table list.
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.