8
Have you been able to solve your problem? I'm often surprised at how people treat novices on these boards.
To be more helpful, you can download the
phpMyAdmin module or the eskuel module. The
eskuel module has a much friendlier interface for the novice database user, in my opinion.
In eSKUel:
1) Click on the link on the left under the globe eSKUel. It should be the name of the database you have XOOPS installed in. (Well, it WILL be... it's the only database you can edit from within one of these modules.)
2) This will expand the list. In the center column you will see a long list of the tables.
3) Put a checkbox next to the name of the table you want to delete.
4) Scroll all the way down to the BOTTOM of the list. There are some actions hyperlinked there. The SQL term for deleting a database is "DROP", so click on the "Drop the tables" link.
5) eSKUel will come back with a typical "Are you sure you want to delete this" dialog. It will tell you the name of the table(s) and the number of table(s) you are about to drop/delete. Make sure that you are ONLY deleting the one table that you mean to delete.
It should go without saying that you should be VERY careful using these tools if you are new to databases. These tables drive a large part of your website. It is definitely an area that you don't want to play around in. You should learn what the database looks like. I believe it's helpful to understand what the database is doing on the back-end... but again, I must stress that you must be very, very careful!
Thanks!