How to find a module's sql table?

ring_c · Involved Joined: Dec 28, 2003 Posts: 276 Location: Israel

I want to remove some modules, along with their sql tables.
Is there a way to find the exact tables to be removed along with the module itself?

Raven · Posted: Thu Sep 29, 2005 2:57 pm

Hmmmm. Be careful. Backup everything you touch, just in case.

Usually, if you look at all the php files in the modules/MODULE_TO_BE_REMOVED/ folder and search for sql_ , you will find all references to any table being used. Now, obviously there are tables that you would not remove, like $prefix."_users". If you look in the nuke.sql file that came with your install you will see the core nuke tables. Leave those alone. Any other table is probably unique to your module and safe for removal. If you have doubts you can either ask or rename the table through phpMyAdmin after you remove the files and see if you start getting any errors. That's what I usually do.