PDA

View Full Version : Deleting Database Files


jacksmack
2-13-04, 04:15 AM
How do you delete files stored in your sql database? I've done it before, for example removing all of the openchat database files and retaining the phpboard files. But somehow I have forgotten how to do this.
Thanks.

cherria
2-13-04, 04:41 AM
Do you mean, how do you remove database tables?

If so, then in whatever front end to MySQL you use, the command is

DROP TABLE your_tablename

execute this for each table you want to remove. There is probably a menu option in the GUI you use, but this SQL command widd do the same for you.

jacksmack
2-13-04, 12:54 PM
thank you

mitchind
2-13-04, 01:29 PM
It's very simple in the phpMyAdmin frontend.

Click on your Database, and at the bottom of the table list, "Select All" and then choose Drop from the pull-down list. Or you can check only the tables you want deleted.